After you open the control account balances (Step 4), your A/R, A/P, and stock balances appear twice: once in the old accounts imported from QuickBooks, and again in the new control accounts. In this step, you post journal entries at the cut-off date to offset the old accounts so each balance is only counted once.
You will post three offsetting journal entries:
- Offset the A/R balance
- Offset the A/P balance
- Offset the stock balance
Before you start
All three offsets are made with the Journal Entry function. Go to Accounting > Journal Entry. If you have not used it before, see the Journal Entry article for detailed instructions.
Offset the A/R balance
After you open the A/R balance, the total outstanding A/R is doubled: it is the amount in the old A/R account (11000) plus the amount in the new A/R account (12000). Post a journal entry that clears the old A/R account (11000), as shown below.
)
Offset the A/P balance
After you open the A/P balance, the total outstanding A/P is doubled: it is the amount in the old A/P account (20000) plus the amount in the new A/P account (21000). Post a journal entry that clears the old A/P account (20000), as shown below.
)
Offset the stock balance
After you open the stock balance, the total stock-on-hand value is doubled: it is the amount in the old inventory account (12100) plus the amount in the new inventory account (13000). Post a journal entry that clears the old inventory account (12100), as shown below.
)
Note: The account numbers above are from our example. Use the account numbers from your own chart of accounts.
Next: Step 6: Verify Opening Balance Data.