Cleanup and reconciliation
How to clean up uncategorized transactions
A step-by-step triage for uncategorized income and expense buckets, with the reclassification entries that fix them and rules that stop them coming back.
By TNas · · 8 min read
To clean up uncategorized transactions, export everything sitting in the uncategorized (or "ask my accountant") accounts, sort it in a fixed order, and move each item to its correct account with a reclassification entry. Deal with transfers, loan payments and payments of existing bills and invoices first, because they aren't income or expenses at all. Then categorize the true income and expenses, and set up rules so the bucket stays empty.
Uncategorized accounts are created when a bank feed imports a transaction that nobody has assigned to an account yet. They're convenient for a day or a week. Left for months, they make the profit and loss statement unreliable.
Why uncategorized balances are a problem
An uncategorized transaction is a bank or card transaction that has been imported into the books without being assigned to a real account.
A bank feed has to put every imported transaction somewhere. When no rule matches, most accounting software drops money coming in into an uncategorized income account and money going out into an uncategorized expense account. Both are real accounts in the chart of accounts, so they flow into your reports.
That causes problems in both directions:
- Profit is wrong. A $1,450 payment to the business credit card sitting in uncategorized expense makes expenses look $1,450 higher, even though paying a card is not an expense. The purchases on the card were the expenses.
- The balance sheet is wrong. That same card payment should have reduced Credit card payable. Until it's fixed, the liability is overstated.
- Taxes are harder. The IRS page What kind of records should I keep explains that supporting documents for expenses should show the payee, the amount paid, proof of payment and the date incurred. An uncategorized line rarely has that link to a document.
Uncategorized accounts are a cousin of the suspense account. The difference is mostly who created them: suspense is a deliberate bookkeeper's tool, uncategorized buckets are the software's default. The suspense account guide covers the logging habits that apply to both.
Before you start
Gather these first, so you aren't stopping every few minutes to hunt for something:
| Item | Why you need it |
|---|---|
| A report of every transaction in each uncategorized account | Your working list |
| Bank and credit card statements for the same period | Full transaction descriptions |
| Open invoice and unpaid bill lists | To spot payments of existing documents |
| Loan statements or amortization schedules | To split payments into principal and interest |
| Receipts, emails and supplier invoices | Evidence for each expense |
| The owner, available for questions | Some items only they can explain |
Export the list to a spreadsheet and add three columns: "What it is", "Correct account" and "Evidence". Sorting a spreadsheet by payee and amount is far faster than clicking through transactions one at a time.
A triage order that works
Work the list in this order. Each pass removes items that would otherwise be miscategorized in the next one.
Pass 1: transfers between your own accounts
Look for matching amounts going out of one business account and into another: bank to savings, bank to credit card, bank to a payment processor. These are not income or expenses. A credit card payment reduces Credit card payable. A transfer to savings moves money from one Cash account to another.
Pass 2: loans and owner money
Loan proceeds increase Notes payable. Loan payments must be split using the lender's statement: principal reduces Notes payable, and interest is Interest expense. Money the owner puts in is a contribution to Owner capital, and money the owner takes out for personal use is a draw. None of these belong on the income statement except loan interest.
Pass 3: payments of bills and invoices you already recorded
If you use accrual bookkeeping, many supplier bills and customer invoices are already in the books. A payment of a recorded bill reduces Accounts payable, and a customer payment of a recorded invoice reduces Accounts receivable. Categorizing these as an expense or as revenue counts them twice. The paying suppliers lesson shows the normal entry.
Pass 4: recurring payees
Sort the rest by payee. Recurring costs, for example rent, utilities, software, insurance and payroll services, tend to repeat monthly at similar amounts. Categorize one, confirm it, then apply the same account to the rest and write a bank rule for the future.
Pass 5: everything else, one by one
What's left should be a short list of one-off purchases and deposits. Match each to a receipt or invoice. Watch for items that are really assets, such as equipment over your capitalization threshold (see capitalizing fixed assets), and for personal purchases made from a business account.
Pass 6: true unknowns
If you and the owner genuinely can't identify an item, don't guess. Move it to a suspense account with a log entry stating what you know and who you asked. That keeps the expense accounts clean while the question stays visible.
Worked example: reclassifying the bucket
Birch Lane Landscaping is a fictional sole proprietorship. After a few months without reviews, its uncategorized expense account holds $3,184.50 and its uncategorized income account holds $2,500.00. The triage spreadsheet shows:
| Bucket | Amount | What it really is | Correct account |
|---|---|---|---|
| Expense | 1,450.00 | Payment to the business credit card | Credit card payable |
| Expense | 890.00 | Equipment loan payment (812.40 principal, 77.60 interest) | Notes payable, Interest expense |
| Expense | 612.00 | Payment of a mulch supplier's bill already entered | Accounts payable |
| Expense | 232.50 | Mower blade sharpening, receipt found | Repairs and maintenance expense |
| Income | 2,000.00 | Owner moved personal savings into the business | Owner capital |
| Income | 500.00 | Customer paid an open invoice | Accounts receivable |
The expense items total 1,450.00 + 890.00 + 612.00 + 232.50 = 3,184.50, and the income items total 2,000.00 + 500.00 = 2,500.00, so every dollar in both buckets is accounted for.
The reclassification entries
A reclassification entry moves an amount from one account to another. Cash isn't touched, because the bank side was already recorded correctly when the transactions were imported. Only the other side was wrong. One compound entry can clear each bucket:
| Account | Debit | Credit |
|---|---|---|
| Nov 30: reclassify items from uncategorized expense | ||
| Credit Card Payable | $1,450.00 | |
| Notes Payable | $812.40 | |
| Interest Expense | $77.60 | |
| Accounts Payable | $612.00 | |
| Repairs and Maintenance Expense | $232.50 | |
| Uncategorized Expense | $3,184.50 | |
| Nov 30: reclassify items from uncategorized income | ||
| Uncategorized Income | $2,500.00 | |
| Owner Capital | $2,000.00 | |
| Accounts Receivable | $500.00 | |
The debits in the first entry add up to 1,450.00 + 812.40 + 77.60 + 612.00 + 232.50 = 3,184.50, matching the single credit. Both buckets are now zero.
Look at the effect on profit. Before the cleanup, the $3,184.50 in uncategorized expense counted as an expense. After it, only $77.60 of interest and $232.50 of repairs are expenses, a total of $310.10. Expenses drop by $2,874.40, which is the amount that was never an expense at all. On the income side, $2,500.00 of "revenue" turns out to be an owner contribution and a collection, so revenue drops by $2,500.00. Both changes are why an uncategorized balance makes a profit and loss statement unreliable.
Separate lines or one entry?
Many accounting products let you recategorize each bank transaction directly instead of posting a journal entry. That's fine, and often better, because each transaction keeps its link to the bank line. Use a journal entry when the transactions are in a closed period, when your software doesn't allow editing them, or when you want one documented cleanup entry for the accountant. The split lines and allocation lesson covers splitting one transaction across several accounts, which you'll need for every loan payment.
Stopping the bucket from filling up again
A cleanup only lasts if the causes are fixed.
- Write bank rules for recurring payees. Rules should match on payee and, where possible, amount range. Review new rules once before trusting them, since a bad rule miscategorizes every future transaction.
- Capture receipts at purchase time. A photo of the receipt attached to the transaction answers the question before it's asked.
- Record transactions often. IRS Publication 583 suggests recording transactions daily when you can. Even weekly is a big improvement over quarterly.
- Keep business and personal spending apart. Publication 583 also says to keep your business account separate from your personal account. Most mystery items come from mixing them.
- Review the buckets in your close. Add "uncategorized accounts are zero" to the month-end checklist, right after the bank and card reconciliations.
- Ask the owner one batch of questions. A short weekly list ("What was the $86 at the hardware store on the 12th?") gets answered. A list of 140 items at year-end doesn't.
If you start a cleanup in the middle of the year, reconcile each month's bank and card statements as you go. Reconciled months give you a fixed starting point, so later fixes don't break earlier ones.
Frequently asked questions
Can I just delete uncategorized transactions that I can't identify?
No. They are real movements of money, and deleting them makes the Cash balance disagree with the bank. Move true unknowns to a suspense account and keep investigating.
How far back should I go?
Back to the last month that was fully reconciled, or the start of the current year if nothing has been. For earlier years that were already reported on a tax return, ask the business's tax professional before changing anything.
What if a transaction is half business and half personal?
Split it. The business part goes to the right expense account, and the personal part goes to Owner drawings for a sole proprietor. Keep the receipt showing the split.
Practice reclassifying entries
A cleanup is mostly correcting entries and compound entries, done carefully and many times. Practice with the correcting entry exercises and the compound journal entry exercises, and review the correcting entries lesson if the reclassification logic still feels new. If the backlog covers many months, the guide to catch-up bookkeeping explains the order to work in, and how to reconcile a business credit card statement covers the card side.
Sources
- What kind of records should I keep — IRS
- Publication 583, Starting a Business and Keeping Records — IRS
Educational content for US small-business bookkeeping, not tax, legal or accounting advice. Example businesses and figures are fictional. See our editorial policy for how we write and correct content.