Manager Starting Balances - BC Bookkeeping Tutorials|dwmbeancounter.com

Starting balances are used only when migrating accounting for an entity to Manager from a prior accounting system. They can be set only for balance sheet accounts or, when appropriate, for their subsidiary ledgers. (See information below.) They are not used for new businesses just beginning operation. Starting balances on the date you begin using Manager should equal ending balances for equivalent accounts in the old accounting system.

Notes
Versions of Manager prior to 21.8.41 included various schemes for entering starting balances that required establishing a defined start date in the Settings tab. The prior requirement for a defined start date no longer exists. As used in Guides, start date refers to the date you begin recording your day-to-day transactions in Manager. As described below, certain transactions from before the start date may still be entered; but, those should all be transactions that were also entered in your prior accounting system.

Starting balances are only set for accounts on the balance sheet, not the profit and loss statement, because balances of accounts on the profit and loss statement depend only on transactions during the current financial period. In other words, starting balances are only entered for asset, liability, and equity accounts.

The starting balance of the Retained earnings account is determined automatically by the program as other starting balances are entered. This ensures the accounting equation (Assets = Liabilities + Equity) is always in balance. If the starting balance of Retained earnings in Manager does not match the closing balance of your prior accounting system after all other starting balances are entered, you have one or both of two problems. Either (1) you have entered another starting balance incorrectly in Manager or (2) your prior accounting system balance sheet was out of balance. Identify and correct the source problem. Do not attempt any adjustment to the Retained earnings account, as that is not possible.

Starting balances are entered in one of three ways, depending on whether they pertain to:

Manager allows only one method for any account, subsidiary ledger, or transaction, so you cannot choose incorrectly.

An ordinary account is one you add yourself in the Settings tab, from the Chart of Accounts page:

Ordinary accounts do not include those added automatically by Manager when certain functional tabs are created. Nor do they include control accounts created from the Control Accounts page in Settings. For accounts with an Edit button next to their names in the chart of accounts, click the button. If they are ordinary accounts, a Starting balance field will be available:

Select whether the starting balance is a debit or credit from the dropdown list, enter the balance (always as a positive number), and click Update.

Note
Starting balances for asset accounts are normally debits, unless the account is a contra asset account (one where the balance is usually negative). Starting balances for liability accounts are usually credits, unless the account is a contra liability account. Starting balances for equity accounts are credits when the business owes money and debits when the business is owed money.

Example
Sample Consulting, a sole trader, switches its accounting to Manager at the beginning of the calendar year. On the day it begins using Manager, Sample Consulting has a liability in its Tax payable account for taxes collected from customers but not yet paid to the tax authority. So it enters a starting balance credit by editing the Tax payable account in Chart of Accounts under the Settings tab:

Note

If you don't setup a Tax Payable account in the chart of accounts a default account is automtically enabled. The beginning balance of this account is determined from the sales tax amounts entered on the unpaid sales invoices using the cash basis of accounting.

If using accrual a Tax payable account needs to be setup in the Chart Of Accounts and the tax code(s) setup and assigned (Settings-tax codes) where you can enter a beginning balance.

Subsidiary ledgers can be thought of as subaccounts of control accounts. Control accounts may be activated automatically when certain functional tabs are enabled. They may also be custom control accounts you define on the Control Accounts page in the Settings tab. They include:

Starting balances are not set directly for control accounts of any type. Instead, they must be set for individual subsidiary ledgers (subaccounts). To set a starting balance for a subsidiary ledger, go to the tab used for defining that type of subaccount. Default relationships are:

Note
If control account assignments for subsidiary ledgers have been changed from the defaults above, starting balances are still set in the default tabs listed. Once you are in the tab where the subsidiary ledger or subaccount is defined, click Edit for that ledger and enter the starting balance.

After Update is clicked, all three modified accounts from the two Examples show their correct starting balances on the Summary page:

The final category of starting balances requires additional steps. A simple, summary balance at the subsidiary ledger level would not be sufficient, because future transactions or events may be linked to ones from before you began using Manager. Therefore, the prior transactions themselves must be entered, with transaction dates before your Manager start date. Such transactions include:

Sales and purchase invoices not fully paid (accounts receivable and accounts payable) as of your start date are entered exactly like normal invoices, but with dates before your start date. If an invoice has been partially paid, only its remaining balance due is entered. Manager uses these pre-start invoices to establish starting balances for Accounts receivable and Accounts payable. Because you will initially set your reporting period to begin on your start date, pre-start invoices will not affect your income or expense accounts. During later reporting periods, they will also be similarly ignored.

Carefully consider inventory items on pre-start invoices. If items on a sales invoice were already delivered under the prior accounting system, add the quantities back to the starting balances for those inventory items, because the pre-start sales invoice tells Manager they are being delivered again.

Likewise, if items on a purchase invoice were already received under the prior accounting system, subtract them from starting balances for those inventory items, because the pre-start purchase invoice tells Manager they must be received again.

If you will be using delivery notes or goods receipts to track quantities of the items involved, be sure to also enter those transactions. (Dates can match actual delivery or receipt dates, even if they are pre-start.) Your goal in adjusting starting balances for inventory items is to leave only the receivable or payable aspect of an invoice outstanding.

Note
More information about starting balances for customers is here. More information on suppliers is here.

Pending bank transactions are entered in the Receipts and Payments tabs, using dates before your start date. The Status field must be set to Pending. As with pre-start invoices, deposits and withdrawals themselves will not affect income or expense accounts, because the transactions will be dated before the beginning of your reporting period.

I recommend ignoring pending transactions and just enter your actual book cash balances that assume all pending transactions have cleared.