Books Current / Guides
Why does bookkeeping take so long every month?
Bookkeeping takes long every month when last month’s loose ends are still there. Bank lines nobody reviewed, payments stuck in Undeposited Funds, duplicates, accounts never reconciled, and the same categories picked by hand every time. Each one makes the next month slower. Here is how to spot each one in QuickBooks Online, and the guide that fixes it.
Updated 2026-10-06. Steps refer to QuickBooks Online and link to Intuit’s own help articles.
| Cause | Fix |
|---|---|
| Bank lines waiting in Pending | A short weekly session, so the pile is never more than a week. |
| Payments stuck in Undeposited Funds | Record the bank deposits, and clear old payments oldest first. |
| Duplicates in the books | Exclude them while they are still in Pending. Fix the ones already in the books one pair at a time. |
| Accounts not reconciled | Reconcile each account once a month, when the statement arrives. |
| No bank rules | Set rules for the charges that look the same every month. Leave auto-add off at first. |
Bank lines are waiting in Pending
QuickBooks sends downloaded transactions to the Pending tab and suggests a category for each one. They wait there until someone posts them. Go to Bank transactions, pick the account, and look at how many lines are in Pending and how old the oldest one is.
A week of lines is quick, because you still remember what each one was. Months of lines means working that out again for every line. A short weekly session keeps the pile to one week.
Source: Categorize online bank transactions in QuickBooks Online ↗
Read next: Exclude, match or categorize: which one in QuickBooks Online?
Payments are stuck in Undeposited Funds
Intuit describes Undeposited Funds as a temporary lockbox that keeps payments until you record a formal bank deposit. If deposits are never recorded, the payments stay there. The deposit in the bank feed then has no record in QuickBooks with the same total, and someone has to work out which payments made it up.
Open the Undeposited Funds account from the Chart of accounts. If the payments in it go back months, clear them oldest first.
Source: Managing your Undeposited Funds account ↗
Read next: Undeposited Funds in QuickBooks: what it is and how to clear it
Duplicates are hiding in the books
Intuit notes that duplicates can appear when transactions download from your bank after you already uploaded them by hand. Another copy appears when a bank line is added as new instead of matched to a payment or bill you already entered.
Either way, the books stop agreeing with the bank, and the next reconciliation turns into a search. Exclude duplicates while they are still in Pending. Fix the ones already in the books one pair at a time.
Source: Exclude duplicate transactions in QuickBooks Online ↗
Read next: Duplicate transactions in QuickBooks Online: find them and remove them safely
The accounts are not reconciled
Reconciling is how you know a month is finished. Intuit has you match each transaction in QuickBooks to your statement until the Difference is $0.00, which means the account is balanced.
Without that check, a missing or doubled transaction can sit unnoticed until something forces a look. Then you are searching several months at once. Reconcile each account once a month, when the statement arrives.
Source: Reconcile an account in QuickBooks Online ↗
Read next: How to reconcile an account in QuickBooks Online for the first time
No bank rules are set up
Intuit says that when you set up bank rules, QuickBooks enters categories and descriptions into transactions for you. Go to All apps, then Accounting, then Rules, and select New rule.
Start with the charges that look the same every month: phone, software, insurance, fuel. Leave auto-add off at first. Intuit warns that with auto-add on, you will not get a chance to review transactions before QuickBooks adds them to your books.
Source: Set up bank rules to categorize online banking transactions ↗
Read next: How to categorize transactions in QuickBooks Online without making a mess
If you are already months behind
Then a monthly routine is not enough on its own. Catch up first, one account and one month at a time, oldest first. Start the weekly routine once the books reach the current month.
Read next: How to catch up on bookkeeping when you are months behind
Questions
Why does bookkeeping take so long every month?
Because last month’s loose ends are still there: bank lines nobody reviewed, payments stuck in Undeposited Funds, duplicates, accounts never reconciled, and the same categories picked by hand every time. Each one makes the next month slower.
How often should I do bookkeeping?
Review bank lines in a short weekly session, and reconcile each account once a month, when the statement arrives.
What do bank rules do in QuickBooks Online?
Intuit says that when you set up bank rules, QuickBooks enters categories and descriptions into transactions for you. Leave auto-add off at first, because with it on you will not get a chance to review transactions before they are added.