Excite Tax's short list: business and personal money in one account, accounts never reconciled to their statements, contractor payments with no information return, employees paid as contractors, sales tax booked as income, and expenses backed by a bank line but no receipt. Each one is in the table below.
What mistakes do owners make doing their own bookkeeping?
Most do-it-yourself errors come from trusting the bank feed: the same payment imported twice, transfers between the business's own accounts counted as income, whole loan payments posted as expense, and an uncategorized account nobody empties. None of them shows up until someone reconciles. The full list is below.
What are the red flags of bad bookkeeping?
A cash balance in the books that differs from the bank statement, a negative bank or card balance the bank never showed, a suspense account that keeps growing, payroll or sales tax liabilities that never clear, and a profit figure the bank balance cannot explain. The full list is below.
What are the top five startup bookkeeping mistakes?
Paying business costs from a personal account, losing track of what was spent before opening, picking an accounting method by accident on the first return, not setting money aside for estimated tax, and keeping no records behind the numbers. Each one, with the rule behind it, is below.
The mistakes, and what each one breaks
Bookkeeping mistakes fall into two groups. Some make the books wrong, and a wrong return is built from them. Others leave the books right but unprovable, which costs nothing until someone asks for proof. The table lists the common ones in both groups, with the fix for each.
Common small-business bookkeeping mistakes
Mistake
What it breaks
Fix
Personal and business spending in one account
Every line has to be sorted twice, and personal costs slip through as deductions
The IRS says to reconcile the checking account each month. A reconciliation compares the books with the bank's statement and forces every difference to be explained. Skip it and the bank feed's errors stay in: a payment imported twice, a deposit that never arrived, a transfer counted as a sale. They are cheap to fix in the month they happen and expensive a year later, when nobody remembers what a payment was for.
A bookkeeping file that has never been reconciled is not a set of books yet, whatever its reports look like. What a bank reconciliation is walks through one.
The bookkeeping mistake behind a missed form is usually upstream: contractors paid by card, app or cash, with no running total per payee and no taxpayer identification number collected at the start. In January the totals then have to be rebuilt from bank lines. Keep a payee list from the first payment and the forms become a report, not a project.
Owners who keep their own books make a predictable set of errors, and almost all of them come from letting software post transactions nobody checks.
The same payment imported twice, once by the bank feed and once by hand.
Transfers between the business's own accounts recorded as income on one side and expense on the other.
Loan payments posted entirely to expense, when only the interest is an expense and the principal reduces the loan.
Credit card payments recorded as expenses, on top of the card charges that were already expensed.
Owner contributions and loan proceeds recorded as sales, which inflates income and the tax on it.
An uncategorized or suspense account used as a parking lot and never emptied.
Bank rules that categorize every charge from a vendor the same way, including the personal ones.
Two of these change the tax in opposite directions. Loan proceeds booked as sales overstate income, so the owner pays tax on borrowed money. A card payment expensed on top of its charges deducts the same spending twice, which understates income and is the kind of error the penalty below is aimed at. How to do your own bookkeeping sets up a routine that catches each one.
Each of these means the reports cannot be trusted yet. None needs a bookkeeper to spot.
The cash balance in the books differs from the bank statement for the same date, and nobody can list why.
A bank, cash or credit card account shows a negative balance the bank never did.
An uncategorized or suspense account holds a balance that grows every month.
Payroll tax or sales tax payable never returns to zero after a return is paid, or has gone negative.
Reported profit is healthy but the business is short of cash, with no loan payments, inventory or unpaid invoices to explain the gap.
Owner withdrawals appear as meals, supplies or other expenses.
No month has been closed or locked, so last year's numbers can still change.
Contractor totals for the year cannot be produced without going back through bank statements.
One flag is usually a few months of cleanup. Several at once usually means reconciling from the last clean point, and the cleanup guide gives the order.
What inaccurate bookkeeping costs
Bad books cost money three ways: tax paid on income that was never earned, deductions lost for want of proof, and penalties when the return built on them understates the tax.
there shall be added to the tax an amount equal to 20 percent of the portion of the underpayment to which this section applies... (1) Negligence... (2) Any substantial understatement of income tax
Say the correct tax for the year is $30,000 and the return, built from books that missed a run of deposits, shows $24,000, so the understatement is $6,000.
The $6,000 understatement is larger, so it is substantial, and the 20% penalty adds $1,200 on top of the $6,000 of tax.
An owner claiming the section 199A deduction gets the same answer here: 5% of the correct tax is $1,500, and $5,000 is still the greater figure.
Had the understatement been $4,000, it would not be substantial, but books too poor to support the return can still bring in the same 20% penalty as negligence.
(d) A seller is not required to maintain a separate account for the tax collected... (e) Taxes collected by a seller pursuant to this chapter shall be held in trust for the benefit of the state
Fix them in this order: reconcile the accounts, then correct the categories, then deal with any return filed from the wrong numbers. The cleanup guide gives the steps, the catch-up guide covers years rather than months, and the month-end close checklist keeps the books from drifting again.
When to hand this to a preparer
Hand the books over when keeping them costs more hours than the business can spare, or when they stop agreeing with the bank.
Excite Tax keeps these books; the return they feed is reviewed and signed by a licensed CPA at TBD CPA LLC.