How a Seattle E-Commerce Brand Cleaned Up 18 Months of Books Before a Loan Application
Sam's List Editorial | 2026-07-14
This is an illustrative scenario, representative of the kind of loan-readiness bookkeeping work described below. Details are anonymized and the figures are for illustration; results vary by business.
A loan officer does not care how strong your fourth quarter felt. She cares whether the numbers in front of her reconcile. This representative case study follows a Seattle e-commerce brand that had to clean up its books before a business loan could close, after 18 months of do-it-yourself bookkeeping produced a gap that nearly killed the deal.
The Pushback
The brand sold across Shopify, Amazon, and a wholesale channel, and had grown fast enough to need a working capital loan to buy inventory ahead of a busy season. The bank's underwriting team asked for 18 months of reconciled financials: a profit and loss statement, a balance sheet, and bank statements that actually matched the books.
That last part was the problem. The founder had been running QuickBooks off memory and habit, not process. Transactions were categorized inconsistently, inventory purchases were expensed the day they were bought instead of tracked to cost of goods sold, and sales tax collected across a dozen economic-nexus states had never been reconciled against what was actually remitted.
The loan officer's message back was blunt: the revenue on the P&L did not match what was landing in the bank account, and the file could not move to underwriting until it did.
The Gap That Almost Sank It
The specific problem turned out to be merchant fees. Shopify Payments, PayPal, and Amazon all deposit net of processing fees, but the books had been recording the full transaction amount as revenue without booking the fee as a separate expense. Over 18 months, that inflated top-line revenue and understated the real margin the underwriter needed to evaluate the loan.
It is an easy mistake to make and a hard one to catch without looking. Every individual deposit looked roughly right. It was only when the bank matched total deposits against total booked revenue, month by month, that the mismatch showed up. A gap that size, unexplained, reads to an underwriter as a bookkeeping problem or something worse, and either read stalls a loan.
The Bookkeeping Catch-Up Before the Loan Application
Rebuilding 18 months of books from scratch is not a weekend project, and any timeline promising otherwise should be treated with suspicion. The realistic version of this work looked like this:
Bank and card feeds were reconnected and every transaction re-categorized against the actual chart of accounts, not guessed at after the fact. Each month's Shopify, PayPal, and Amazon settlement reports were reconciled against actual deposits so merchant fees were booked as an expense instead of quietly folded into revenue. Inventory purchases were moved onto an accrual basis, so cost of goods sold reflected what was actually sold in a given month, not what was bought. Sales tax collected was reconciled state by state against what had been remitted, which surfaced a smaller but real gap in two states past economic nexus thresholds.
The trailing 12 months, the period underwriting weighed most heavily, were prioritized first, with the remaining six months of history filled in behind it. A clean rebuild across three sales channels and a dozen tax jurisdictions realistically runs six to eight weeks of focused work, not a few days, and any business in this position should plan financing timelines around that reality rather than around the deadline they are hoping for.
What Changed Once the Numbers Tied Out
Once the reconciled financials were in the underwriter's hands, deposits matched booked revenue, margin looked like what the business actually earned, and the sales tax exposure was disclosed and quantified rather than discovered later. That is what let the lender evaluate the real risk instead of guessing at it.
In this representative scenario, the loan was approved, and the rate offered improved from the bank's initial indication once the file no longer carried unresolved reconciliation flags. That outcome is not guaranteed and should not be read as typical. Clean books do not obligate a lender to approve anything or to offer better terms; they simply give the lender accurate information to underwrite against. A business with real credit or cash flow problems will not fix them by fixing its books. What clean books remove is the separate, avoidable risk of a lender not trusting the numbers at all.
Why It Took a Seattle Bookkeeper for E-Commerce, Not a Weekend
Catch-up bookkeeping across multiple sales channels, inventory-based COGS, and multistate sales tax is not the same job as monthly bookkeeping for a services business, which is part of why the backlog built up in the first place. System Six, a Seattle bookkeeper for e-commerce and real estate businesses founded in 2009, has built its practice around exactly this kind of inventory, multichannel, and multistate work.
Confirm scope, pricing, and current availability directly before engaging. Review System Six's profile on Sam's List, where you can see their specialties and how they describe their process before you get on a call.
Frequently Asked Questions
Why do lenders want reconciled books before approving a business loan? Underwriters need to trust the numbers before they can price risk against them. If bank deposits do not match booked revenue, the lender cannot tell whether the business is healthy or whether the books are simply wrong. Reconciled financials remove that uncertainty and let underwriting move forward on the actual numbers.
What is the most common bookkeeping mistake that trips up a loan application? Recording gross payment processor deposits as revenue without booking the merchant fee as a separate expense is a frequent one for e-commerce sellers. It inflates revenue and understates margin, and it often stays invisible until someone matches total deposits against the P&L line by line.
How long does an 18-month bookkeeping catch-up realistically take? For a business selling across multiple channels with inventory and multistate sales tax, plan on roughly six to eight weeks of focused work, not a few days. Reconciling settlement reports, rebuilding cost of goods sold, and checking sales tax by state each take real time, and rushing them defeats the purpose.
Does cleaning up books guarantee a loan gets approved? No. Clean books give a lender accurate information to underwrite against, but they do not override real credit, revenue, or cash flow problems, and approval and rate depend on the lender's own criteria. What clean books remove is the separate risk of a lender not trusting the numbers at all.