Allodial Resources logo Allodial ResourcesBusiness funding, explained plainly
Funding Readiness

Clean Up Your Chart of Accounts Before a Loan Application

A client sent me her profit and loss statement three days before a bank appointment, and the expense section ran to 71 lines. One of them was called Misc and carried $14,380 for the year.

A bookkeeper comparing a long printed expense list against a bank spreading template on a laptop, with a highlighter marking vague account names

A client sent me her profit and loss statement three days before a bank appointment, and the expense section ran to 71 lines. One of them was called Misc and carried $14,380 for the year. Two others were called Supplies and Office Supplies, and both had activity in the same months. Her numbers were fine. Her ledger was not.

An underwriter does not read your profit and loss the way you do. They copy it into a spreading template with maybe twenty fixed rows, and anything that does not map cleanly gets parked, questioned, or dropped onto a line that hurts you. I have watched a file sit for nine days while a loan officer waited for an answer about one account name. Tidying the chart of accounts is unglamorous work and it is the cheapest thing you can do to shorten an application.

What spreading does to a messy ledger

Most commercial analysts work from a spread: your last two or three fiscal years plus an interim period, laid side by side in the bank's own format. The template has a fixed shape. Revenue, cost of goods sold, a short list of operating expense categories, officer compensation, depreciation, interest, and a couple of lines for one-time items. Your 71 accounts have to land somewhere inside that shape.

When a name is ambiguous the analyst makes a choice, and the choice is rarely generous. Contract Labor often gets pushed into cost of goods sold, which moves your gross margin. Travel and Meals usually lands in general overhead rather than selling expense, which makes your fixed cost base look heavier than the business next door. Misc gets flagged, and a flag becomes a question, and a question becomes an email that sits unanswered while you are out on a job.

The spread also drives the ratios. Debt service coverage is built from the spread, not from your software dashboard. If depreciation is buried inside an account called Equipment instead of sitting on its own line, the analyst may not add it back, and your coverage falls for no reason except naming. That is the same reason it pays to know how a lender reads a profit and loss statement before you print one.

The accounts that get questioned first

After enough of these you learn which names draw a pen mark. Roughly in order of how often I see them cause a delay:

  1. Misc, Other, Sundry, and anything vague. If a catch-all account holds more than about 2 percent of total expenses, expect to explain it line by line.
  2. Owner draws recorded as an expense. Draws belong in equity. Sitting in expenses they understate your profit, and the analyst who spots them has to decide whether you understood the difference.
  3. Near duplicate accounts. Supplies next to Office Supplies, Repairs and Maintenance next to Repairs, Insurance next to Business Insurance. Each pair raises a quiet doubt about whether the coding is reliable at all.
  4. Loan payments booked as a single expense. A $2,100 monthly payment coded entirely to Loan Expense hides the principal portion, which should reduce a liability rather than your profit. This one actively makes your financials worse than reality.
  5. Personal items inside business accounts. The pet insurance, the warehouse club run, the phone line for a teenager. Small amounts, large credibility cost.
  6. Accounts with no activity for three years. Clutter. Not damaging, but they lengthen the statement and shorten the reader's patience.

That Misc account turned out to be mostly hand tools under $300 and two annual software renewals. Twenty minutes of recoding brought it down to $1,240, which nobody asks about.

The advice to just collapse everything is wrong

You will read that lenders want a short chart of accounts, so the cure is to merge hard until you have fifteen or twenty expense lines. I disagree with half of that. What a lender wants is accounts that map to their template without judgment calls, and over-merging destroys the mapping just as thoroughly as sprawl does.

Fold Subcontractors into a general Payroll account and you have made it impossible for the analyst to see that two thirds of your labor is variable, which is the best argument you own in a slow quarter. Fold Fuel into Vehicle Expense beside lease payments and you lose the ability to show that a diesel price spike, not weak demand, explained the margin dip. I keep a 40 to 50 line expense list for most trades clients and no banker has ever said it was too long. They object when a name is vague, not when there are many names.

There is a second reason for restraint. A wholesale restructure of prior-year accounts means the statements you hand the bank stop matching the tax returns the bank already has. That mismatch is worse than an untidy ledger. If you re-map history, re-map the categories and keep the totals identical, then carry a one-page crosswalk showing where each old account went.

A two-evening cleanup, in order

The sequence matters, because the later steps depend on the earlier ones. Budget about three hours the first night and two the second.

Start by exporting the full chart of accounts and the trial balance for the last completed year into a spreadsheet, side by side, sorted by amount descending. The top twenty accounts carry roughly 90 percent of the story, so that is where your hours go.

Next, get your bank's spreading categories. Ask the loan officer for the list. They usually send it, because a pre-mapped statement saves them work as well. Add a column and write the target category beside each of your accounts. Anything you cannot assign in five seconds needs renaming or splitting.

Then fix structural errors before cosmetic ones. Move draws to equity. Split loan payments into principal and interest. Pull depreciation onto its own line. Separate cost of goods sold from operating expenses if your software let you blur the two. Those four changes alter reported profit and coverage. Renaming Supplies to Shop Supplies does not.

Last, merge the dead accounts and mark them inactive rather than deleting them, so prior-year reports still run. Re-print the profit and loss for the same year and compare net profit against the tax return. If the two differ by anything other than known tax adjustments, stop and find out why before the bank does.

When the cleanup turns up real commingling

Sometimes the coding is not the problem. Sometimes there genuinely is $9,000 of personal spending running through the operating account. Recoding it out of expenses and into owner distributions raises your reported profit, which helps coverage, and in the same motion it shows a larger owner draw than the old statements implied. Both facts become visible at once.

Say it first, in your own words. A one-page memo attached to the financials, three short paragraphs, naming the reclassification and showing net profit before and after, does more for your credibility than a clean statement with an unexplained jump. What worries an analyst is not that an owner takes money out of the business. It is that a number moved and nobody volunteered a reason.

If the commingling is deep enough that two full years would need rebuilding, push the application back a quarter and open a separate operating account this week. One clean quarter plus a plausible explanation holds up better than a rushed rebuild that falls apart under the second question. The rest of the pack deserves the same patience, and the other guides under funding readiness cover what a lender asks for alongside the statements.

FAQ

How far ahead should I do this?

Four to six weeks before you apply. That leaves room to re-run two prior years, tie them to the tax returns, and write the memo. Done in the week before the meeting, it usually produces statements that do not reconcile.

Will the bank ask for my chart of accounts by name?

Not often. They ask for the profit and loss, the balance sheet, and general ledger detail on anything they query. The chart of accounts quietly shapes all three, which is why it gets ignored.

Is my accounting software's default chart good enough?

It is a reasonable start and a poor finish. Defaults are built for a generic business, so trade specific costs arrive with no obvious home, and that is exactly where catch-all accounts are born.

Should I pay someone to do the cleanup?

If the work is naming and merging, two evenings of your own time will do it. If draws, loans and inventory are tangled across several years, a cleanup engagement usually runs $600 to $1,500, which is less than a quarter point of rate on a five-year note.

CW
Callum Whitfield

Callum keeps the books for a handful of small businesses and sees their cash flow problems months before the owners do. He writes about forecasting and funding math the way he explains it to a client staring at a spreadsheet.

More posts by Callum

More in Funding Readiness

01doorganico 084goad 3hot8 4465456 after5internprogram ahandfulofblessings ahmadpc ahomcybersecurity annodex antiquesandperiodcollectibles aotc asianworldkashmir beedlectrics bloggertemplatefree bluefeatheragency bodyweightsolution campaign08blog carfixadvisor catstreetcollective cbstvsports cnfanspurchasing committeeof500yearsofdignityandresistance covertopsdjs cs-kaiyuangame cuestacomunicaciontotal cxoutlet dancebetgame deskgearhub destinyvillastay detectmagazine di33 diamondsteelbuildings donmo dyanadropship emarsysfinance emimattl escapechan eskitarih evautoplay everythingweddings-orlando farmzone feedviewerapp foxstudiosscratch gamevui123 gleasongrade greetingsday hacklabasu haskell iw-kaiyun jagoanproperti jilidskripsi joltbusinessfinance juegodepokergratis juegospucca kaeru-festival latestmehndidesigns lestanzediottaviano litemagazines localcommunityhero lustrsazan mariashebets menswheels newwebstechs1 nikkit ootheday oxigenvpn plurfitness prefetial probudgetcarpetcleaning psychicmrsmartin pyaten qvantor rejoignezlogis rexzbot riselayouts ruchin rwxqsgd5 sakaltime shibiaowang shop-bot skrtips strcoding tetapatrium topselller uneplanteartificielle vipertechcr webtech1223411 wo-kygaming yamaha-mekar yeknava yoybuysheets zenunwa yamaha-mekar jilidskripsi ankertoto ankertoto ankertoto ankertoto