Scribd Logo
Upload

Welcome to Scribd!

  • 269 views

    Sample Accounting Excel

    Uploaded by

    Clarisse30
    The document contains a trial balance sheet for a company with account codes and balances. It also includes sections for income and expenses with details on sales, payments, and assets with categories and acquisition dates.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Sample Accounting Excel

    Uploaded by

    Clarisse30
    269 views23 pages
    The document contains a trial balance sheet for a company with account codes and balances. It also includes sections for income and expenses with details on sales, payments, and assets with categories and acquisition dates.

    Original Description:

    Sample Accounting Excel

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a trial balance sheet for a company with account codes and balances. It also includes sections for income and expenses with details on sales, payments, and assets with categories and acquisition dates.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    269 views23 pages

    Sample Accounting Excel

    Uploaded by

    Clarisse30
    The document contains a trial balance sheet for a company with account codes and balances. It also includes sections for income and expenses with details on sales, payments, and assets with categories and acquisition dates.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 23

    Accounting Journ

    Business Name: COMPANY NAME


    Account Code Account Trial Balance Adjusting Entries
    Debit Credit Debit
    BS-10 Petty Cash
    BS-11 Cash in Bank
    BS-12 Accounts Receivable
    BS-13 Long-Term Receivable
    BS-14 Input Tax
    BS-15 Fixed Assets
    BS-16 Accumulated Depreciation
    BS-17 Consruction-in-Progress
    BS-18 Other Assets
    BS-20 Accounts Payable
    BS-21 Long Term Liabilities
    BS-22 Output Tax Payable
    BS-30 Owner's Equity
    BS-31 Owner's Drawing
    IS-1000 Service Revenue
    IS-1001 Sales
    IS-1002 Other Income
    IS-2000 Direct Labor
    IS-2001 Direct Materials
    IS-2002 Advertising & Marketing
    IS-2003 Bank Charges
    IS-2004 Consumables & Cleaning
    IS-2005 Insurance
    IS-2006 Office Expenses
    IS-2007 Postage
    IS-2008 Professional & Legal Fees
    IS-2009 Salaries & Wages
    IS-2010 Subscriptions & Memberships
    IS-2011 Telephone & Internet
    IS-2012 Training
    IS-2013 Travelling & Accommodation
    IS-2014 Electricity
    IS-2015 Gas
    IS-2016 Oil
    IS-2017 Licenses
    IS-2018 Depreciation
    Total 0 0 0
    ounting Journal
    Accounting Period: 12/31/2017
    Adjusting Entries Adjusted Trial Balance Income Statement Balance Sheet
    Credit Debit Credit Debit Credit Debit Credit
    0 0 0 0 0 0 0
    COMPANY NAME
    Income & Other Receipts

    Official Sales
    OR/Invoice
    Receipt Invoice Customer Name
    Date
    Number Number
    *FILL UP ONLY THOSE IN YELLOW
    -

    Tax Inclusive
    Customer Address Customer TIN Number Description
    Amount
    Tax Bank Payment Exclusive Inclusive
    Tax Amount Account Code
    Code Code Date Amount Amount
    COMPANY NAME
    Expenses & Other Payments

    Date
    Supplier TIN
    Expense Supplier Supplier Address Reference
    REF Number
    Incurred
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    *FILL UP ONLY THOSE IN YELLOW

    Tax Inclusive Tax Bank Payment


    Description
    Amount Code Code Date
    Exclusive Inclusive Account
    Amount Tax Amount Amount Code
    COMPANY NAME
    Machineries, Equipment Set-up
    www.excel-skills.com
    Asset Asset ID Acquisitio Asset
    Category Tax Code
    Number Number n Date Type
    *FILL UP ONLY THOSE IN YELLOW

    Current Trn Last PY Last PM Disposal


    Class Last Trn Date
    Date Trn Date Trn Date Date
    Proceeds
    Historical
    on
    Cost
    Disposal
    COMPANY NAME
    Detailed Description of Projects

    NAME OF PROJECT:

    STATUS
    Cash Amount PHP -
    Financed Amount PHP -
    Total Alloted Funds PHP -
    Funds Used to Date PHP -
    Funds Remaining PHP -

    DATE
    ITEM CATEGORY
    RECORDED
    COPY PASTE THIS SHEET IF THERE ARE SEVEAL PROJECTS STARTED

    REFERENCE
    DESCRIPTION FROM EXPENSE COST
    EXCEL

    You might also like