ZeraBooks Guides

The journal records each transaction in date order as equal debits and credits. The general ledger sorts those same entries by account, so each account has a running balance. The trial balance lists every account's ending balance on one page and confirms total debits equal total credits. Same data, three views: by transaction, by account, then summarized. The three terms get used interchangeably, which makes accounting harder to learn than it needs to be. Following five transactions through all three views makes the difference concrete. Five transactions Pawsome Grooming, a fictional mobile dog groomer, starts business in October 2026: October 1: the owner puts 10,000.00 of her own money into the business bank account. October 3: she buys a grooming table and dryers for 4,200.00 on the business credit card. October 1 to 31: she earns 3,150.00 from grooming appointments, all paid into the bank. October 5: she pays 1,400.00 rent for a parking and storage space. October 28: she pays 2...

No. QuickBooks Online's bank upload accepts a CSV file, so a PDF statement converted to a three-column or four-column CSV imports without any .qbo file. What a .qbo file adds is a unique ID on each transaction that helps QuickBooks skip duplicates. With CSV, you prevent duplicates yourself, by uploading whole statement periods that don't overlap. People searching for a "PDF to QBO converter" usually want one thing: transactions from a statement in QuickBooks without typing them. The .qbo format is one way there, but not the only one, and for QuickBooks Online it's rarely necessary. What QuickBooks Online accepts In QuickBooks Online, the bank transactions upload takes several file types, including CSV and Web Connect files (.qbo). For CSV, it accepts two layouts: Three columns: Date | Description | Amount 10/02/2026 | Customer payment 4471 | 2,400.00 10/05/2026 | Office rent | -1,850.00 Four columns: Date | Description | Credit | Debit 10/02/2026 | Customer paymen...

 To match a restaurant location's card deposits to its sales, start from the POS card total for the month, subtract the last batch still in transit at month end, subtract the processing fees the processor withheld, and the result should equal what landed in that location's bank account. Book the fees as an expense so sales stay at the full POS figure. ZeraBooks does this monthly for each location. With one location, a small gap between card sales and deposits is annoying. With three or four, it's where real money goes missing without anyone noticing, because each location's numbers blur into the others'. The month-end match for one location A fictional example. One location of a restaurant group, October 2026. | | Amount | |---|---| | POS card batches for October (sales, tax and tips) | 74,300.00 | | Less: October 31 batch, deposited November 2 | (1,210.40) | | Less: processing fees withheld by the processor | (1,634.60) | | Card deposits in the location's a...

 If your old bookkeeper won't hand over the books, you can still switch. Your bank and card statements come straight from your bank, and they're what every month is proven against anyway. A new bookkeeper can rebuild the books from your last filed tax return and the statements since. It's slower and priced as catch-up. ZeraBooks takes on rebuilds like this. It's a stressful spot to be in. Maybe the relationship ended badly. Maybe the bookkeeper simply stopped replying. Or the service you used closed its doors. Either way, you need the books, and the person or company holding them isn't helping. First, ask once more, in writing Before rebuilding anything, send one clear, polite written request. List exactly what you want: admin access to the books file if the subscription is in your name, or a full export if it isn't; a trial balance, balance sheet and profit and loss for the last month they finished; the bank and card reconciliation reports for that month; an...

 When you undo an old reconciliation in QuickBooks Online, every reconciliation after it is undone too. The transactions stay, but they go back to uncleared, and the saved reconciliation reports and attachments for those months are permanently deleted. Only the primary admin, an accountant user or an in-house accountant can do it. ZeraBooks works differently: you can take back one month's sign-off and leave the rest alone. That cascade is the part people don't expect. They want to fix one month and find they've reopened half a year. A fictional account, January to September A checking account in QuickBooks Online has been reconciled every month from January to September 2026. In May, the reconciliation wouldn't clear, and someone saved it with a 112.50 adjustment. Now the accountant wants that adjustment gone and the real cause found. | Month | Before | After undoing May | To redo | |---|---|---|---| | January to April | Reconciled | Reconciled | Nothing | | May | R...

 AI accounting software should never do the arithmetic, overwrite a category you chose, delete a possible duplicate, guess what a tax payment was, or move money. Those are the lines ZeraBooks, an AI-native general ledger, draws for its own AI. They're also a fair test for any accounting tool that says AI does the bookkeeping. More accounting products now say AI does the work. That's useful, and it raises a question owners and accountants should ask out loud: what is the AI allowed to do without me? The answer tells you more about a product than any demo. 1. Do the arithmetic Balances, totals, depreciation, loan interest, the amount on a journal entry. All of these have exactly one right answer, and a ledger can compute them exactly every time. A language model produces likely-looking output, which is the wrong tool for a number that has to be right to the cent. In ZeraBooks, the AI decides what a line means. The ledger's own code computes every figure. When a statement ...

 To fix loan payments that were booked entirely as an expense, get the lender's statements for those months, add up the principal portion, and move it from the expense account back to the loan payable account with a correcting journal entry for each period. Then check the loan balance against the lender's latest statement. ZeraBooks' bookkeeping team does this as part of catch-up work. It's one of the most common repairs in small business books, and one of the more satisfying ones, because the result is easy to prove. When you're done, your loan balance matches the lender's to the cent. What went wrong Each loan payment has two parts. Interest is an expense. Principal reduces what you owe. If someone recorded the whole withdrawal as "Loan payment" in an expense account, then every month the expenses were overstated by the principal, and the loan on the balance sheet never moved. A fictional six months A small bakery took a 60,000.00 equipment loan...

 Per diem for truck drivers is a tax calculation applied when the return is prepared, not a transaction in the books. In the U.S., drivers under DOT hours-of-service rules can use $80 a day in the continental U.S. ($86 outside) and deduct 80% of it. In Canada, long-haul drivers deduct 80% of meal costs, with a simplified $23 a meal, up to three a day. ZeraBooks keeps the records that calculation needs. A lot of drivers keep every meal receipt from the cab in a shoebox and hand it over at tax time. Under per diem, most of those receipts aren't what matters. What matters is the count of qualifying days away from home. The U.S. side The IRS sets a special transportation industry meal and incidental rate. It is $80 a day in the continental U.S. and $86 a day outside it, for the period October 1, 2025 to September 30, 2026, and again for October 1, 2026 to September 30, 2027. Drivers under the Department of Transportation hours-of-service limits can deduct 80% of that amount. And on...

 Clear uncategorized transactions biggest and easiest first: transfers and card payments, then deposits, then recurring merchants, then owner and personal spending, then loans and one-off purchases, and finally one list of questions for whatever is left. Working in that order shrinks the pile before you reach the lines that need thought. ZeraBooks does the same triage automatically from your reviewed history. The instinct is to start at the top of the list and work down by date. That's the slowest way. You make the same decision about the same vendor eight times, and you reach the hard lines while the easy ones are still cluttering the screen. A fictional pile of 40 lines A small cleaning company has 40 lines sitting in Uncategorized for September 2026. Sorted by type, they break down like this: | Type of line | Lines | |---|---| | Transfers between its own accounts | 6 | | Credit card payments from checking | 4 | | Customer deposits | 9 | | Recurring merchants (5 vendors) | 14...

 WorkSafeBC payroll reports are due quarterly on April 20, July 20, October 20 and January 20 for employers expecting premiums of $2,000 a year or more, with a reconciliation by February 28. Smaller employers report once a year on an assigned date in early March. Either way, the books need assessable payroll by period. ZeraBooks, a Surrey bookkeeping service, keeps those totals ready. The third-quarter report was due on October 20, two days ago. If it went in late or took a scramble, this post is for you. Quarterly or annual: which are you? WorkSafeBC sets it. If your premiums are expected to reach $2,000 a year or more, or your classification unit has to report quarterly, you report every quarter. Under that, you report annually, on a date WorkSafeBC assigns you: March 3, 5, 7, 9 or 11. Quarterly reporters report payroll for the quarter by the 20th of the month after it ends, then send a reconciliation for the year by February 28. What the premium looks like, roughly Premium...

Monthly bookkeeping for a simple small business, with one or two accounts and a manageable number of transactions, can start around $150 a month from a bookkeeping service; that's where ZeraBooks starts. The quote goes up with the work: more accounts to reconcile, more transactions, platform payouts to gross up, payroll, inventory and how often you want reports. It shouldn't go up because of your revenue alone, your industry label or the word "AI". Catch-up work for months already behind is a separate, one-off price. Here's how to read a bookkeeping quote, and how to sanity-check one. What actually drives the monthly price? Think in units of work, not in business size. Each of these adds real time every month: Driver Why it adds work Number of bank and card accounts Each one is reconciled to its own statement every month Transactions per month Each line is recorded and categorized; this grows with volume, not revenue Platform payouts Each Sho...

An IOLTA three-way reconciliation compares the adjusted bank balance, the trust journal and the total of the client ledgers on the same date. When all three agree, the account as a whole is in balance. It doesn't prove each client's balance is right: money posted to the wrong client leaves the totals unchanged. That's why the client listing gets read line by line, not just added up. Here's a made-up month that shows both halves. The firm Delacroix Law Office is fictional: one attorney, one paralegal, one IOLTA account. The September 2026 statement closes on September 30 at 27,940.00. Step 1: adjust the bank balance Two items haven't cleared: A 3,500.00 retainer from a new client, Reyes, deposited after the bank's cutoff on September 30. A deposit in transit. Check 1108 for 650.00 to a process server on the Tan matter, mailed September 28. An outstanding check. Adjusted bank balance: 27,940.00 + 3,500.00 − 650.00 = 30,790.00. Step 2: the trust journal Th...

A balance sheet reconciliation template needs one row per balance sheet account and eight columns: the account, its ledger balance, the outside document that supports it, the support balance, the difference, the explanation, the correcting entry, and who prepared and reviewed it. Fill it in at each month-end, starting with cash, and the month is closed only when the difference column is all zeros. Below is the layout, then one made-up studio's October filled in. The columns Column What goes in it Account Every asset, liability and equity account with a balance Ledger balance From the trial balance at month-end Support The outside document: statement, report, schedule, contract Support balance The figure from that document, same date Difference Ledger minus support Explanation In words, not just a number Entry The journal entry that fixes it, if any Prepared / reviewed Initials and date The support has to come from outside the account. A ledger report proving the ledger proves n...

To get a Capital One statement into Excel or CSV, sign in at capitalone.com, click the account, choose View statements, download the month's PDF, and run it through a bank statement converter. Before you use the file, check that the previous balance plus charges, minus payments and credits, equals the new balance printed on the statement. Then pick the layout that suits where the data is going. Here's each step, with a made-up card statement. Step 1: download the PDF, not the transaction export On a computer, sign in at capitalone.com and click the card or bank account. Each account has its own statements, so a business with a Spark card and a checking account downloads from two places. Choose View statements, pick the month and download the PDF. Capital One keeps up to seven years of statements online for open bank accounts. You'll also see an option to download transactions for Quicken, QuickBooks or Excel. It's handy for a glance, but it usually has no opening or...

When OCR misreads a bank statement, the converted rows no longer add up to the printed closing balance, and the size of the gap usually tells you what kind of mistake it was. A gap of twice one line is a lost minus sign. A gap of 99 times a line is a lost decimal point. A gap divisible by 9 is often two swapped digits. A round gap like 6,000.00 is one digit misread in the thousands place. That makes the balance check more than a pass or fail. It's a pointer. Here's how to read it, with made-up numbers. Start with the one sum Opening balance + deposits − withdrawals = closing balance. Run it on the converted rows. If it lands on the closing balance the bank printed, every line is very likely right. If it doesn't, write down the gap: rows total minus printed closing. Fingerprint 1: a gap of twice one line A withdrawal of 215.40 is read without its minus sign, or without the "DR" next to it. Instead of taking 215.40 off, the rows add 215.40. The total is now 430...

To put mortgage statements into Excel, give each monthly payment one row and split it into principal, interest, escrow and fees, then add two check columns: one proving each row adds up to the amount paid, and one proving the principal balance rolls forward to what the lender printed. Ten minutes per year of statements, and the spreadsheet proves itself. ZeraBooks Convert, the statement converter I'll mention at the end, doesn't read loan or mortgage statements yet, so this is the by-hand method. It works with any lender. The columns Payment date Total paid Principal Interest Escrow Fees Principal balance after Escrow balance after Check: total minus parts (should be 0.00) Check: previous principal balance minus principal minus balance after (should be 0.00) Put a first row above the payments with the balances before the first one. Every formula after that refers to the row above. A worked quarter This is a made-up rental property mortgage: 4.75% fixed, principal and inte...

A medical practice needs a normal small business chart of accounts plus a handful of practice-specific ones: patient revenue split into insurance and patient payments, a contra account for refunds, merchant fees, medical supplies, malpractice insurance, practice software, and owner pay kept apart from wages. About 35 to 45 accounts covers most small clinics. Below is a numbered starting chart and one made-up month booked against it. A starting chart Numbers in the 1000s are assets, 2000s liabilities, 3000s equity, 4000s revenue, 5000s and up costs and expenses. Leave gaps so you can add accounts later without renumbering. Number Account Notes 1010 Operating checking One account per bank account 1020 Payroll checking If payroll runs from its own account 1500 Medical equipment Tables, imaging, chairs, at cost 2010 Business credit card One per card 2100 Payroll liabilities Withholdings and employer taxes owed 2500 Equipment loan Matched to the lender's statement 3100 Owner contribu...

A Canadian small business's books have to be ready before each CRA deadline, not on it: the GST/HST return one month after each monthly or quarterly period, T4 slips by the last day of February, and the income tax return, which for a sole proprietor is due June 15 with the balance owing April 30. Below are the 2027 dates for two made-up businesses, worked out from the CRA's rules. Both businesses are fictional. Both have a December 31, 2026 year-end. The two businesses Ridgewood Tile is a sole proprietor in Mississauga. GST/HST registered, filing quarterly by choice. One part-time employee. Reports business income on Form T2125 inside the owner's T1 return. Alder Bay Media Inc. is a small Canadian-controlled private corporation in Vancouver. GST/HST registered, filing quarterly. Three employees. Files its own T2. The 2027 calendar When Ridgewood Tile (sole proprietor) Alder Bay Media Inc. (corporation) By January 31 Q4 2026 GST/HST return and payment Q4 2026 GST/HST...

Year-end bookkeeping is finished when every bank, card and loan account in your books matches a statement dated December 31, the loose ends are cleared, and your accountant has a trial balance they can file from. Most of the work happens in the first three weeks of January, once the December statements exist. Here is the checklist, then one made-up business worked through it. The checklist Download the December statement for every account: checking, savings, each credit card, the merchant account and every loan. Reconcile each one so the December 31 balance in the books equals the printed balance. If a card statement closes before December 31, add the charges from the last days of the month so the year is complete. Clear anything sitting in uncategorized, suspense or "ask my accountant". Check each loan against the lender's statement and split the year's payments into principal and interest. List contractors paid during the year, with the amounts that count toward a...

 A bank statement converter is trustworthy when it proves its own output: the opening balance plus every deposit, minus every withdrawal, has to equal the closing balance the bank printed, to the cent, before you download anything. Without that check, a converter can read 49 lines perfectly and swap two digits in the 50th, and the file will look exactly as clean as a correct one. If a tool doesn't run the check, you have to. Here's why that one equation does so much work, and what it can't do. What does the check catch? Dovetail Joinery is a fictional cabinet shop. Its June statement prints: Opening balance: 11,275.90 Total deposits: 14,620.00 Total withdrawals: 12,947.35 Closing balance: 12,948.55 11,275.90 + 14,620.00 - 12,947.35 = 12,948.55. The statement ties to itself. Now suppose a converter reads its 38 lines and makes one of the classic mistakes. The gap left behind tells you what happened: What went wrong Example Result against the printed closing Two digits ...

 A small business chart of accounts groups every account by type and gives each type its own block of numbers. The classic four-digit scheme puts assets in the 1000s, liabilities in the 2000s, equity in the 3000s, income in the 4000s and expenses from the 5000s up. ZeraBooks uses the same idea with five digits: assets from 10000, liabilities 20000, equity 30000, revenue 40000, cost of revenue 50000, operating expenses 60000, other income 80000 and other expenses 90000. The free template below follows that scheme with 44 accounts. The numbers look like bureaucracy on day one. They earn their keep later. Why do the ranges matter later? Reports sort themselves. A profit and loss lists revenue, then direct costs, then operating expenses, then the odd items at the bottom. If the numbers follow that order, every report reads top to bottom without anyone arranging it. You can tell an account's type from its number. 22100 is a liability before you read the name. That helps more than ...