2026-11-17 · Accounting

Behind on Your Bookkeeping? How to Catch Up Before Tax Season (Step-by-Step Plan With Formulas)

↓ Get the free Excel + PDF kit for this article

It happens to almost every small business at least once: a busy season, a staff change or a family matter, and suddenly the books have not been touched since spring. Statements pile up, receipts sit in a folder, and the 1099, W-2 and tax return deadlines get closer every week.

The good news is that catching up is a project with a known size. If you measure it first and then work in the right order, you can see on paper — in November — whether you will finish in time. This post shows the exact method, with formulas you can type into Excel or Google Sheets.

Who this is for: owners and office managers who keep their own books (or plan to fix them before handing them to a tax preparer) and are one or more months behind.

Step 1: Measure the backlog before you start

Most people start by opening the oldest statement and typing. That feels productive but hides the real question: will this be done by my deadline? Answer it first with four numbers:

  1. First month not done (for example, January 2026).
  2. Number of business bank and credit card accounts.
  3. Transactions per month across all accounts. Open one busy month's statements and count the lines.
  4. Hours you can really spend per week.

Then use three planning assumptions you can adjust: about 1.5 minutes per transaction to enter and categorize, about 20 minutes per account per month to reconcile, and a few hours (say 4) to gather files and do a final review. Raise the minutes if your receipts are messy.

Step 2: Turn the numbers into hours and a finish date

Put the inputs in a small sheet. In the example below, cells B1–B11 hold the inputs and the formulas go in column D.

CellInputExample (made-up)
B1First month not done1/1/2026
B2Last month to finish12/1/2026
B3Accounts3
B4Transactions per month180
B5Hours per week6
B6Minutes per transaction1.5
B7Reconcile minutes per account-month20
B8Setup + review hours4
B9Start date11/23/2026
B10Target date3/15/2027

Now type these formulas:

In this example the owner finishes about four weeks before a March 15 target. If the result is negative, you know in November — not in March — that you must add hours, move the target or narrow the scope.

Timeline from November 2026 to April 2027 showing federal deadlines and an example finish date of February 15, 2027
Figure 1. Example finish date against the 2027 federal deadlines (example values).

Step 3: Work in this order (it prevents redoing work)

Flowchart of the 10-step bookkeeping catch-up order from gathering statements to locking the period
Figure 2. The 10-step catch-up order.
  1. Gather every statement for every account and month — bank, credit card, loan and card-processor payout reports.
  2. Confirm the opening balance. The first month must start from the last reconciled balance, or the balance sheet on your last filed return.
  3. Enter or import one month at a time, oldest first, one account at a time.
  4. Sort deposits. Loan proceeds, transfers from your other accounts, owner contributions and refunds are not sales (see Figure 3).
  5. Categorize expenses consistently — same vendor, same category.
  6. Match transfers between your own accounts, including credit card payments, so nothing is counted twice.
  7. Split loan payments into principal and interest using the lender's statement.
  8. Record payroll and sales tax from their reports, not just the net bank line.
  9. Reconcile each account for each month. Your ending balance must match the statement.
  10. Review the profit and loss month by month, then lock the period in your accounting software.
Decision tree for sorting a bank deposit into sales, transfer, loan, owner money or refund
Figure 3. Not every deposit is income.

Step 4: Track progress month by account

Make a grid: months down the side, accounts across the top. Each cell gets one status — Statement in, Entered or Reconciled. A month is finished only when every account in that row says Reconciled. To see overall progress, type =COUNTIF(B2:D13,"Reconciled")/COUNTA(B2:D13) once every cell has a status.

Before and after comparison: a pile of unfinished months versus a month-by-account tracker with reconciled months in green
Figure 4. From a pile of months to a tracker you can finish.

Keep two side lists as you go: missing documents (what, which month, the date you asked) and unknown transactions (date, amount, description, best guess). Do not let one mystery charge stop a whole month — park it and keep moving.

Three worked examples

A · Solo serviceB · Busy restaurantC · Online shop
Behind sinceSep 2026 (4 months)Jan 2026 (12 months)Jul 2025 (18 months)
Accounts / lines per month2 / 604 / 4503 / 220
Hours per week385
Total hours12.7155121
Finish (start Nov 23, 2026)Dec 28, 2026Apr 12, 2027May 17, 2027
TargetFeb 1, 2027Mar 15, 2027Apr 15, 2027
Result35 days early28 days late → needs 9.7 h/week32 days late → needs 5.9 h/week

All values are made-up examples. The restaurant is the classic surprise: 450 lines a month is 5,400 lines a year. Seeing 155 hours in November is what makes a March date possible. The online shop also has 2025 open — finish 2025 first, because its deadlines have already passed.

Key federal dates for 2026 books

DateWhat is due
Fri, Jan 15, 20274th-quarter 2026 estimated tax (Form 1040-ES)
Mon, Feb 1, 2027W-2s and Form 1099-NEC to workers and to the government (January 31 falls on a Sunday)
Mon, Mar 15, 2027Partnership (Form 1065) and S corporation (Form 1120-S) returns
Thu, Apr 15, 2027Individual (Form 1040) and C corporation (Form 1120) returns
Sep 15 / Oct 15, 2027Extended business / individual returns

An extension gives more time to file, not more time to pay. For payments made in 2026, the Form 1099-NEC/1099-MISC reporting threshold is $2,000 for most payments, so you need contractor totals by early January. State dates can differ.

Common mistakes

FAQ

How long does catching up on bookkeeping take?

Use the formula above. As a rough guide, 1.5 minutes per transaction plus 20 minutes per account per month; a business with 180 lines a month and 3 accounts needs about 70 hours for a full year.

Should I catch up the oldest or the newest month first?

Oldest first. Each month's ending balance is the next month's starting balance.

What if a bank statement is missing?

Download it from online banking or ask the bank to resend it. Enter from the transaction history meanwhile, but do not mark the month reconciled until you have the statement.

Can I file an extension instead?

An extension moves the filing date only. Any tax due is still due on the original date, so you still need a reasonable profit estimate.

Checklist

This article is educational information only and is not tax, legal or accounting advice. Time estimates are planning guesses, not a guarantee. Rules and dates can change; check the IRS and your state.

You can download the ready-made Catch-Up Bookkeeping Planner 2026 for free in the Free kit download box below (Excel + PDF guide, no sign-up).

Sources

Free kit download

Tools to follow this article step by step. No sign-up needed.

Free to use for yourself and your own business; please do not resell or redistribute. General information, not tax, legal or accounting advice; check every figure against your own records.

← All articles Privacy