Undeposited Funds, Suspense and Mispostings: where your books hide their mess

Why parking accounts exist

A bank line arrives and you do not know what it is. A payment comes in and you cannot tell which invoice it pays. The software has to put it somewhere, so each package has an account for exactly this: a holding pen for decisions not yet made.

The problem is never the account. It is that nothing reminds you to come back. A balance that should be zero by the end of each month quietly becomes six months of put-off decisions, and every report built on those books — your profit, your VAT figures, what you are owed — is wrong by at least that amount.

The test is simple: at the end of a month, every account below should have a balance of zero, or close to it and explainable. If one does not, that is where to start.

QuickBooks Online

Undeposited Funds (or “Payments to deposit”)

When you record a customer payment, QuickBooks often puts it in Undeposited Funds rather than straight into the bank, on the assumption that you will group several payments into one lodgement later. If you never record that deposit, the payment sits there for ever — and when the real lodgement comes in on the bank feed and gets added as new income, the same money is counted twice.

Newer files may show the account as “Payments to deposit”. It is the same account; if you are unsure, look for the detail type “Undeposited Funds” in your chart of accounts.

To clear it: open the account’s register and work through the payments oldest first. For each one, find the lodgement on your bank statement that contains it and match them with a bank deposit. If the bank line was already added as income, that income is the duplicate — it is the bank line’s coding that needs to change, not the payment.

Uncategorised Income, Uncategorised Expense and Ask My Accountant

Bank lines accepted without a category land in the Uncategorised accounts; Ask My Accountant is where people put things deliberately to sort out later. Both mean the same thing: your profit by category is not your profit by category.

To clear them: run a report on each account, recode what you recognise, and make a short list of what you do not, with dates and amounts, for whoever can tell you. A list of eight genuine questions is fine; two hundred transactions nobody looked at is not.

Opening Balance Equity

Created automatically when opening balances are entered during set-up. It should be cleared out once the set-up is complete. A balance still sitting there a year later is something your accountant will have to unpick, and pay attention to who is best placed to do that — it often needs their figures from the last set of accounts.

Xero

Suspense

Many Xero files have a Suspense account — added during set-up or by a previous bookkeeper — and it is used the same way: reconcile the bank line now, decide what it was later. The bank looks reconciled, which is exactly why these balances last so long. The reconcile screen shows no problem; the balance sheet does.

To clear it: run Account Transactions for Suspense, identify each line, and recode it to where it belongs. Work oldest first — the oldest entries are usually the hardest, and they do not get easier with time.

Catch-all expense accounts

Not a parking account by name, but General Expenses and Sundry often behave like one. If a large share of your spending lands there, your costs by category tell you nothing, and your accountant will recode them before preparing the accounts.

Historical Adjustment

A system account Xero uses for balancing figures when conversion balances are entered on moving to Xero. It should net to zero once those balances are correct. A balance left behind usually means the conversion figures never matched the previous system’s closing position.

Statement balance against Xero balance

Not an account, but the most useful single number in Xero. Each bank account shows the balance on your statement and the balance in Xero. If they differ by more than the lines still waiting to reconcile, something is missing, duplicated or was deleted after it was reconciled.

Sage 50 and Sage Accounting

9998 Suspense

Sage’s default chart of accounts reserves 9998 for Suspense: postings that nobody knew where to put, and quite often the opening balances from when the company was set up. Like everywhere else, it should be cleared every month.

To clear it: run the nominal activity report for 9998, identify each item, and journal or recode it to the right nominal code. Opening balances that went to Suspense are best done with your accountant, who has the figures they should match.

9999 Mispostings

Sage uses 9999 for Mispostings: entries made when correcting something posted to the wrong place. A balance there means a correction was started and never finished.

Receipts and payments left “on account”

Not a nominal code, but the same problem. A customer receipt that was never allocated to the invoice it paid leaves the invoice showing as owed and the money showing as an unexplained credit. Your debtors list is then wrong in both directions.

Clearing them, in any package

1. Reconcile the bank first. Clearing suspense balances on books that are not reconciled means doing it twice.
2. Work oldest first. Old items are harder, and recent items often turn out to be duplicates of old ones.
3. Keep a list of what you cannot identify, with date and amount, and ask once — not one question at a time.
4. Check the balance at every month end. Zero, or close to it and explainable. This takes a minute and stops it building up again.
5. Do not clear anything by writing it off to an expense account just to make the balance go away. That moves the mess somewhere harder to find.

If you are not sure where the menus are, they move between versions; your software’s own help search for the account name will find the current route.

Not sure what is in yours?

Our free health check looks at exactly these balances, from four standard reports, and tells you what is in them and what to do about it. We identify; fixing it is yours to do, or ours if you would rather.

• Free QuickBooks health check
• Free Xero health check
• Free Sage health check

Or start with the free bank statement check, which works from your bank’s CSV in your browser. And none of this is tax advice — your accountant advises on tax.