Year-End Guide support informationpage qbw:YEG Year-End Guide
QuickBooks Year-End Guide

 

Task A - Close Your Books
Q: What are QuickBooks year-end procedures?
A: QuickBooks is one of the few accounting programs that does not require you to close your books.

QuickBooks makes some automatic adjustments to your books at year-end, and even though you don't have to close your books you can still protect that data. In QuickBooks version 5.0, you can protect last year's transactions from accidental change by using a transaction password. In QuickBooks version 6.0 and later, there is a new password/permissions system that is also used to protect last year's transactions. Advantages to not closing your books:

  • Detail: You always have easy access to last year's data, including the details of every transaction.
  • Reporting: You can create comparative reports between this year and last year. Additional Notes
  • For additional information on year-end tasks, check the index of the onscreen Help and the User's Guide for periodic tasks.
  • For depreciation of fixed asset instructions, check the index of the on-screen Help and the User's Guide for depreciation.
  • For adjustments that transfer money from one income or expense account to another, check the index of the on-screen Help and the User's Guide for general journal, entries.
  • For transaction passwords, check the index of the on-screen Help and the User's Guide for passwords, closing books or period, or passwords, transactions.
  • For yearly tax forms, check the index of your on-screen Help and the Users Guide for tax forms
Automatic year-end adjustments QuickBooks makes

QuickBooks performs certain year-end adjustments, based on the fiscal year start month you entered in the Company Info window under the File menu.

  • QuickBooks for Windows automatically adjusts your income and expense accounts at Year-End to zero them out. Therefore, you start your new fiscal year with a zero net income.
  • QuickBooks for Windows makes an adjusting entry with your net income. It posts it to the Retained Earnings account, which QuickBooks creates automatically.For example, if your profit for the year was $12,000, on the last day of your fiscal year the equity section of your Balance Sheet would show a line for net income of $12,000.
  • On the first day of the new fiscal year, QuickBooks increases your Retained Earnings equity account by the previous year's net income ($12,000 in this example) and decreases your net income by the same amount. This way, you start each new fiscal year with a net income of zero.
Task B - Condense and back up
your data
Q: How do I condense and back up my data?
The Archive & Condense Wizard provides you with several options for condensing your company data file, which can help reduce its size and improve performance. You make step-by-step selections as you progress through the wizard. From the File menu, choose Archive and Condense Data.

Option 1: Condense transactions as of a specific date

This option removes closed transactions dated on or before the specified date and enters monthly summary journal entries for them. Transactions dated after the specified date are retained as are open transactions dated on or before the specified date.

You can improve the effectiveness of condensing by selecting additional transactions to be removed, such as unreconciled bank transactions or invoices that have been marked "To be sent."

After Condense removes transactions, you may be left with list items that are no longer used, such as unused accounts, unused vendors, or To Do Notes that have been marked "Done." You can instruct QuickBooks to remove these items as well.


Option 2: Remove all transactions

This option removes all transactions from your company file. Your lists, preferences, and service subscriptions will be retained. Use this option if you wish to start a new company file without re-entering names and items. (Not available if using payroll or online banking features.)

Backing up: Regardless of which option you choose, the Archive & Condense Wizard will prompt you to make a backup of your company data file before condensing.

Task C- Start a new data file
Q: How do I start a new data file?
From the Company menu, choose Archive and Condense Data. When the Archive and Condense wizard appears, select Remove ALL Transactions if you wish to start a new company file without re-entering names and items. (Not available if using payroll or online banking features - see below.)

I. QuickBooks enables you to start a new company file each year, eliminating the data entry required the first time you set up a file. Please be aware of the following limitations:

  • Due to critical payroll information contained within payroll files, this feature is not available to payroll users.
  • Due to security-related and time-related data from financial institutions, this feature is not available to QuickBooks online banking users.
    You will not be able to run comparative annual reports if you choose to create a new company file.

  • While closing a company file at year-end is not required, many users find that the volume of transactions over the course of a year results in large data files and reduced computer performance. Starting a new company file helps to prevent these problems while providing an extra measure of security against accidental changes to data for a previous tax-reporting period. (It is also possible to make previous years' data secure by assigning a closing date in QuickBooks. A password is required to make changes to the data.)

    II. Prior to starting a new company file, create and print the following reports dated December 31st of last year:

    1. Customer Balance Detail Report
    2. Vendor Balance Report
    3. Balance Sheet (standard)

    You will need these reports to recreate the Accounts Receivable and Accounts Payable year-end balances in the new company file, as well as the opening balances for all Balance Sheet accounts. You will also need to manually enter inventory value, stock status, and any outstanding banking transactions.

    III. To start a new company file:

    1. Make sure you have printed copies of the three reports in Step II above.
    2. From the File menu, choose Archive & Condense Data.
    3. Select Remove ALL Transactions option, then click Next.
    4. When the warning message appears, click Yes..
    5. Click Begin Condense to proceed.
    6. QuickBooks will prompt you to make a backup of your company file, either to 3.5-inch disks or to your hard drive. Also, an archived copy of your original company is created in your QuickBooks directory with the name "Archive Copy MM/DD/YY Company Name." If needed, you can easily restore your original company file from either the backup or archive copy.
    7. Follow the steps to completion.

    Your new company file retains your lists, preferences, and service subscriptions, but no transactions. You may begin entering opening balances for Balance Sheet accounts by choosing Make Journal Entry from the Company menu.

    To rebuild the outstanding balances in Accounts Receivable, you can either create "balance forward" invoices for a lump sum customer balance, or you can recreate individual invoices.
    The Enter Bills option in the Vendors menu enables you to recreate vendor balances, charging these bills directly to the Opening Balance Equity account, as opposed to individual expense accounts.

     
    Help How does the internet backup feature work?
    Task D- Clear Pre-paid expenses
    Confer with your accountant for assistance with clearing your pre-paid and accrued expenses.
    Help QuickBooks Professional Advisors
    Task H- Record Disbursements
    Q: How do I make an adjustment to Retained Earnings?
    A: Retained Earnings can be adjusted in a number of ways.

    You can make transfers to the Retained Earnings account from the registers of other balance sheet accounts; or you can use Retained Earnings in a general journal entry. Your accountant can advise you if adjustments to this account are appropriate.

    While you might adjust the Retained Earnings account to track funds withdrawn by, or distributed to, company owners, Intuit recommends that you create a separate equity account for these transactions. Such accounts are commonly called Owner's Draw. With this method, you know at a glance the total funds withdrawn by the owner as well as the individual transactions that make up the total amount.

    To adjust Retained Earnings from the register of another balance sheet account:

    1. Open the register of the balance sheet account.
    2. Enter an increase or decrease amount with appropriate notes.
    3. Type Retained Earnings in the Account field, and save the transaction.
    To adjust Retained Earnings using a General Journal entry:
    1. From the Company menu, select Make Journal Entry.
    2. Debit or credit Retained Earnings and other appropriate accounts.
    3. Save the transaction.
    To withdraw funds from the company using an Owner's Draw account:
    1. Choose an existing equity account or set up a new equity account, e.g. Owner's Draw, to track owner's draw transactions.
    2. Write out a check to the owner and use the above account in the Account field.
    3. To view entered transactions, open the register of the account chosen in step 1 from the Chart of Accounts.
    Task J - Password-protect
    Your Data
    Q: How do I password-protect my
    QuickBooks data file?
    A: You can set passwords to prevent unauthorized access to your company file or limit the areas that can be accessed within the file.

    To designate an administrator:
    Decide who the administrator will be. Choose someone who is usually available in your office.

    1. From the Company menu, choose Set Up Users.
    2. In the user list, select Admin and then click Edit User.
    3. Enter the name of the person who will be the Admin.
    4. (Optional) Enter a password in the Administrator's Password field. Enter the password again in the Confirm Password field.
    5. Click Next and then click Finish.

    To set the Owner's password:

    1. To assign a password to a new user
      From the Company menu, choose Set Up Users.
    2. Click Add User.
    3. In the User Name field, enter the person who is to receive the password.
    4. Enter the password: first in the Password field and then in the Confirm Password field.
    5. Click Next.
    6. To set up access permissions for this person, follow the instructions that appear.
    Note: It is an expensive and time-consuming process to remove a password from a file, so it is important that you write down the new passwords and save them in a secure place. If you do not remember the owner password, you will not be able to view or print reports, graphs, or registers for your company file. Making frequent backups is a way of protecting yourself, should you forget your new password. You can then restore an old backup that does not have the new password protecting it.