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:
QuickBooks performs certain year-end adjustments, based on the fiscal year start month you entered in the Company Info window under the File menu.
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.
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.
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.
Due to critical payroll information contained within payroll files, this feature is not available to payroll users.
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.
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:
To designate an administrator: Decide who the administrator will be. Choose someone who is usually available in your office.
To set the Owner's password: