What does general ledger software actually do with a bank statement?

General ledger software turns each line on your bank statement into a double-entry record: one side hits the bank account, the other side hits the account that explains it, like rent, a customer's payment, or a loan. Good general ledger software does that posting for you and shows you the result, so the ledger, trial balance and reports all come from the same entries.

People hear "general ledger" and picture something only an accountant opens. It's simpler than that. Here's one real line followed all the way through.

One statement line, start to finish

On September 19, our demo company Northgate Landscaping paid $1,240 to John Deere Financial. On the bank statement it's one cryptic line: CHECKCARD 0918 JOHN DEERE FINANCIAL 800-6334410 IA.

The John Deere payment opened in the ZeraBooks ledger: paid from Bank of America Checking 8803, posted to Notes Payable - Equipment

The same line inside ZeraBooks: paid from the checking account (1060), posted to Notes Payable - Equipment. Northgate Landscaping is a demo company; captured Nov 8, 2026.

What the general ledger records:

AccountDebitCredit
Notes Payable - Equipment$1,240.00
Bank of America Checking 8803$1,240.00

That's the part people get wrong in spreadsheets. A mower loan payment isn't an expense, it pays down a liability. If you dump it into "Equipment expense", your profit looks $1,240 worse than it really is and your loan balance never goes down.

Where does the trial balance come from?

Every entry has equal debits and credits, so when you add up every account, the two columns match. That's the trial balance. If it doesn't balance, something was posted on one side only.

Northgate Landscaping's September 2026 trial balance in ZeraBooks, debits equal credits at $56,272

Trial balance for the same month, from the same ledger: $56,272 in debits, $56,272 in credits.

What should you look for in general ledger software?

  • It posts true double-entry, not a list of categorized transactions.
  • It can explain any number: click a total and see the lines behind it.
  • It checks itself against the bank: statement totals tie to the printed balances.
  • It lets you undo anything.

ZeraBooks does all four from your uploaded bank statements, and it asks you when it isn't sure instead of guessing. More on how it works on our general ledger software page.

Damin Mutti, founder of ZeraBooks. ZeraBooks is accounting software that does your books for you. Upload your bank statements and get back clean, reconciled books. Free setup help on a 15-minute call, plus a free bank statement converter.Also published on: dev.to: the best QuickBooks alternative when your books start from bank statements · Substack: reconciling a month from the PDF statement · Free PDF statement reconciliation worksheet

Comments

Post a Comment

Popular posts from this blog

How to clean up messy books without redoing the same month twice

Image
Clean up books in this order: collect every statement , set opening balances from the last period your accountant signed off, then reconcile each account one month at a time, oldest first . Only once a month ties do you pair transfers, remove duplicates, place uncategorized lines and move owner spending out. A different order means categorizing lines you later delete. A month that doesn't tie, with the gap shown. During a cleanup you stay on that month until the gap is zero. The worked figures below belong to a fictional design studio whose books stopped being kept in February. They are illustrative only. What has to happen before any categorizing? Step 1: Build a statement grid Accounts down the side, months across the top. Tick a cell when you hold that month's statement as a PDF from the bank. Our studio has checking, savings and one card across eight months, so the grid has 24 cells. Any blank cell is a month you can't prove yet, so request it today. Activity...
Read more

How to convert a credit card statement PDF to Excel, step by step

 You need last quarter's card charges in a spreadsheet by Friday, and all you have is three PDFs from the issuer's website. To convert a credit card statement to Excel, download the PDF statement (not the activity export), run it through a converter or copy the tables out by hand, then fix three things: the signs on payments, the foreign currency detail lines, and the summary blocks. Finish by checking that your rows rebuild the printed new balance. Here's each step. Step 1: Download the statement PDF Go to the card's statements page on the issuer's site and download the monthly statement. Many issuers also offer a "download activity" CSV. Skip it for this job. It usually has no previous or new balance printed anywhere, and those two numbers are how you'll prove the spreadsheet is complete at the end. Watch the dates. A card statement ends on a closing date, not the end of the month. If you need the full quarter, you may need the statement after it too...
Read more

How to scan a bank statement so it converts to Excel cleanly

Image
To scan a bank statement so it converts to Excel cleanly, use 300 dpi and grayscale , keep pages straight, save each account's pages into a single PDF , and include the last page even if it looks empty. Then convert it and check that the opening balance plus the rows equals the printed closing balance. Most conversion problems with scanned statements are decided before the conversion starts, at the scanner. Here is how to get it right, step by step. Where a scanned PDF goes in ZeraBooks Convert: the Upload button, or drop the file on the page. Do you need to scan the statement at all? Step 1: Check online banking first Log in and look at the statements section. If the month is there, download the PDF. A downloaded statement carries the bank's own text and will always beat a scan. What scanner settings work best for bank statements? Step 2: Set the scanner Setting Use Why Resolution 300 dpi Lower loses faint digits; higher only makes bigger files Colo...
Read more