Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Finance & Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=411)
-   -   Preparing an accounting worksheet using excel (https://www.askmehelpdesk.com/showthread.php?t=280532)

  • Nov 13, 2008, 11:41 AM
    jackson26
    Preparing an accounting worksheet using excel
    Prepare work sheet showing trial balance, adjustments, adjusted trial balance, income and balance sheet.
  • Nov 14, 2008, 03:00 PM
    pready

    Set up 11 columns for your worksheet.
    Column 1 is the name of your Accounts
    Columns 2 & 3 is your Trial Balance
    Columns 4 & 5 is for your Adjustments
    Columns 6 & 7 is your Adjusted Trial balance
    Cloumns 8 & 9 is for the Income Statement
    Columns 10 & 11 is for your Balance Sheet

    Columns 2,4,6,8,10 are your Debits
    Columns 3,5,7,8,11 are your Credits
    The accounts in the Adjusted Trial Balance transfers to the Income Statement & the Balance Sheet
    The difference in Debits and Credits in the Income Street goes into the Balance Sheet as Retained Earnings.

  • All times are GMT -7. The time now is 04:36 AM.