Preparing for year-end: Hints and Tips for QuickBooks Online (QBO) users

Year-end is quickly approaching. Be prepared for the year-end. Here is a 10-point checklist you should go through to keep your QuickBooks Online accounts in order and plan for the year-end processing.

 

Helpful Checklist:

  1. Bank Reconciliations
    Make sure all bank reconciliations are up to date. This includes credit card accounts as well. Review any unmatched items (both deposits and payments) that you would not expect to be outstanding. This may be the result of a duplicate entry.
    It is important these banks reconciliations are printed (or saved) at year-end.
  2.  

    Click on the screenshots below to enlarge them
    bankrec

     

  3. Undeposited Funds
    Make sure all the customer payment items in Undeposited Funds account have not yet been deposited to the bank account. If all the deposits are already posted to the bank account, this account should show zero balance. Any balance in Undeposited Funds account (even after bank accounts are already reconciled) may be the result of a duplicate entry. Review income and account receivable accounts and resolve it.
  4. uf

     

  5. A/R and A/P Balances on Cash Basis
    Run the Balance Sheet on the cash basis accounting method. If the transactions were properly recorded, these two accounts should not show a balance in the Balance Sheet.
  6. arap_cash_basis

     

  7. Employee Advances
    Make sure Employee Advances account is reconciled. This account should include the advances that are yet to be repaid or have not been deducted from the payroll.
  8. emp_advance

     

  9. Payment to Independent Contractors (1099s)
    Make sure you have IRS Form W-9 on file and they are up to date.
    You can google 1099 and W-9 for all the handy information you need.
  10. track1099

     

    BUY QuickBooks Online – Anytime, Anywhere. Easily Track Sales, Bills and Expenses.
    Beach Vacation Rentals under $100 a night
    Save on Smartphones from Verizon Wireless!
    Over 4000+ STD Test Centers Nationwide. Order Testing Today!

     

  11. Other Balance Sheet Accounts
    Review all other balance sheet accounts. Make sure all assets and liabilities are shown properly. It is also time to make adjustment entries if necessary.

     

  12. bsaccts

     

  13. Depreciation on Fixed Assets
    If you have posted your depreciation on fixed assets entry, make sure these are up to date. If not, consult your Accountant.
  14. depreciation

     

  15. Uncategorized Income & Expense / Ask your Accountant
    If you have any uncategorized income and expense in P&L that have been used to post entries that you aren’t sure what to do with, now is the time to have a look. If needed, ask your Accountant and resolve it. Also, review all income and expense accounts and make sure it makes sense.
  16. uncategorized

     

  17. Retained Earnings
    Keep a separate spreadsheet Account Analysis of Retained Earnings account. This account should include income or loss from prior years. It may also include reclassifying transactions within equity type accounts. Consult your Accountant if it involves any entry posted from outside of equity accounts.
  18. re

     

  19. Close the books
    Close the books once you have submitted final numbers to your Accountant for review and tax preparation. Consult your Accountant in case there is a need to make changes.
  20. closing