Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In Excel, I'm doing an accounting project and was wondering if there a formula I can use to transfer certain numbers from my journal entries
In Excel, I'm doing an accounting project and was wondering if there a formula I can use to transfer certain numbers from my journal entries to my t accounts. For Example, I want all the Debits from the cash account on my General Journal transferred to my debit side of my t-account. What formula would I use to copy all the debits of cash into my debits of my T-account?
Cut Calibri (Body) 2 AA Autosum 2 Wrap Text Copy Fill Merge & Center. $ , % , 400 +00 Conditional Format Cell Insert Delete Format Formatting as Table Styles Clear 1-May cash 50,000 Ad 1 1-May Rent Expense Common Stock 50,000 Prepaid Hent 1-MaySupplies Expense Noces Payable 20,000 1-May Adi 3 31-May Depreciation Expense- Equipment Preforred Stock Paid In Capital in Excess of par 3,000 42,000 Accumulated Depreclation-Eq-pment Preferred Adi4 31-May Deferred Revenve Service Reverve 1-May Equipment 15,000 Ad S31-MayUtilities Expense -May Prepad Rent Utilities Payable 12,000 Ad. 631-yInterest Expense S-May Supplies Accounts Payable 3-May Iwentory Problem 3,630 Cicaing 3L-May Service Revenuc Sales Revenue 6,625 Cleaing 231 May Income Summary 10-May Cost of Goods Sold Seles Discount Cest of Goods Sold Rent Expenee Supplies Expense Depreciation Expene Salaries Expense Interest Expense Utilities Expense 2,925 12-May s Receivble Sales Revenue 3.313 12-May Cost of Goods Sold 1,463 1.463 is-May in Income Summary r tory Accounts Payable 8,775 Retained Earnings Clcaing 331-May Retained Earning ales Discount Accounts Receivable 3,313 Intro. General Journa General Ledger +Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started