A QuickBooks file can contain monthly revenue and expense numbers and still be unreliable. The common warning signs are familiar: the bank balance looks close, but accounts receivable, accounts payable, sales tax, payroll, inventory, equity, and intercompany balances cannot be explained.
The software is rarely the root cause. The real problem is inconsistent transaction design. These are the five issues we see most often in growing and internationally owned businesses.
1. The Chart of Accounts Grows Without Governance
Different users create Consulting, Professional Fees, Professional Services, Legal & Professional, and Other Expense for similar items. Foreign ERP accounts, translated Chinese accounts, and U.S. accounts may all be duplicated. Expenses become fragmented, trends disappear, and tax mapping becomes difficult.
Fix: retain accounts that support management, tax, and audit needs. Do not create a new expense account for every vendor; use the vendor field and, when helpful, class, location, or project dimensions. Limit who can create accounts.
2. Bank Feeds Are Treated as Complete Accounting
A bank feed shows cash movement, not the underlying invoice, tax, fixed asset, prepayment, shareholder loan, or related-party purpose. Common errors include duplicating previously recorded transactions, recording a credit-card payment as another expense, applying broad automatic rules, and duplicating opening balances.
Fix: decide whether the source transaction belongs in an invoice, bill, sales receipt, expense, deposit, or journal entry, and then use the bank feed to match it. Complete monthly bank reconciliations and investigate old outstanding items.
3. E-Commerce and Payment Platforms Are Recorded Net
Amazon, Shopify, Stripe, DoorDash, and similar platforms may combine gross sales, refunds, sales tax, processing fees, advertising, delivery fees, and reserves into one net deposit. Recording only the bank deposit as sales understates revenue and hides refunds, fees, and tax liabilities.
Fix: record platform activity using a gross-to-net settlement entry. Separate gross sales, discounts, refunds, marketplace-collected tax, fees, and platform receivables, and reconcile the result to the bank payout.
4. AR/AP Workflows Are Mixed With Cash Coding
If an invoice is created and the later deposit is coded directly to income, revenue is duplicated. If a bill is entered and the bank payment is coded directly to expense, the expense is duplicated. At the opposite extreme, avoiding invoices and bills entirely means the company cannot see customer balances, unpaid vendors, or aging.
Fix: define which transactions use accrual workflows. Apply customer receipts to invoices and vendor payments to bills. Customer deposits, deferred revenue, and prepayments generally belong on the balance sheet until earned or used.
5. There Is No Month-End Close, Review, or Lock Date
Without a close process, prior periods remain open to continuous changes. Payroll entries are omitted, sales tax payments are expensed, fixed assets are written off immediately, inventory does not match cost of goods sold, and intercompany balances differ between entities.
Fix: use a month-end checklist and a close-the-books date. Reconcile banks, cards, AR, AP, payroll, sales tax, inventory, fixed assets, loans, equity, and intercompany accounts. Lock the period and require review for later changes.
Three Additional Cross-Border Risks
- Multi-currency accounting: the parent’s local-currency books, the U.S. dollar ledger, and the actual settlement currency require consistent remeasurement and FX treatment.
- Related-party activity: parent-paid expenses, management fees, loans, inventory purchases, and allocations should not all be placed in one generic due-to/due-from account.
- Imported journal entries: translating descriptions and account names is not enough. U.S. classification, customer and vendor naming, debit/credit logic, sales tax, and payroll treatment must be reviewed.
A Practical Cleanup Sequence
1. Back up the file and establish a historical cutoff date.
2. Reconcile banks, cards, and debt to create a reliable cash baseline.
3. Clean duplicate accounts, Opening Balance Equity, and uncategorized activity.
4. Rebuild AR/AP, platform settlements, payroll, and sales tax.
5. Reconcile fixed assets, inventory, equity, and intercompany balances.
6. Document adjustments and implement a new close checklist and lock policy.
Good bookkeeping is not the act of categorizing every bank transaction. It is a controlled system in which each balance has support, reconciles, feeds accurate returns, and gives management useful information.
