iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Use one Excel transaction table as your cash book, then summarize its entries by account and month to create a ledger view. Enter each transaction promptly, retain its supporting documents, and reconcile the workbook with your bank statement monthly. This is a practical recordkeeping setup, not a full double-entry accounting system or a guarantee of tax compliance.
Cash book vs. ledger: what each one does
A cash book records money received and paid, with enough detail to identify each transaction. An account ledger groups transaction totals by account, such as sales, rent, or supplies. The IRS describes a journal as a record of business transactions shown by supporting documents and a ledger as totals from journals organized into accounts (IRS Publication 583).
In Excel, a useful arrangement is to enter each transaction once in a master table and derive ledger summaries from that table. This avoids duplicate data entry. It is a workbook design recommendation, not a format required by the IRS. A simple cash-in/cash-out workbook is not, by itself, a complete general ledger: in double-entry bookkeeping, each transaction posts debits and credits, and total debits equal total credits.
Set up the workbook
1. Read Me / Setup sheet
Record the business name, fiscal period, currency, opening cash balance, account or category list, and brief instructions for anyone entering transactions. State whether payment amounts are entered as positive values in their own column or as negative values in one signed Amount column.
#1 Best Overall
- PERFECT FOR RECORD KEEPING: The 2 Pack account ledger books are versatile and can be used to track finances, budgets, expenses, and other business or personal records. They are perfect for individuals, entrepreneurs, or small business owners who need a reliable and efficient way to keep track of their finances. With 100 pages, customers can record transactions over an extended period, making it a handy tool for financial planning and organization.
- COMPACT AND LIGHTWEIGHT: The account ledger books are compact and lightweight with each book weighing 7 ounces and measuring 8.5 x 6.25 inch, making them easy to carry around. You can take them with them in a bag or briefcase, making them ideal for on-the-go use. This feature ensures that you can access your records at any time, whether you are at work or on the move.
- DURABLE KRAFT COVER: The kraft cover is a distinguishing feature of these account ledger books. It provides a durable layer of protection that can withstand daily wear and tear, making it suitable for long-term use. Additionally, the classic, rustic appearance of the cover gives it a timeless and professional look that can fit in any setting.
- PREMIUM QUALITY: Elegant style with the words ''Account Tracker'' embossed in fancy Gold Foils. The gold coil ring binding is a practical design feature that enhances the functionality of the account ledger books. It allows pages to turn smoothly and easily, making it effortless to flip through the book while keeping pages in place. The ring binding also ensures that pages won't fall out, preventing the loss of vital information.
2. Transactions sheet
Create one row per transaction and format the range as an Excel table with headers. A practical set of columns is:
- Date and transaction ID
- Description and customer, vendor, or other source
- Account or category
- Receipt amount and payment amount
- Payment method and bank or reference number
- Supporting-document filename or location
- Cleared or reconciled status, if you use the workbook for bank reconciliation
Keep the evidence itself—such as an invoice, receipt, deposit slip, paid bill, or statement—not just a note in the spreadsheet. IRS recordkeeping guidance says business records should support entries and be complete, accurate, and accessible, including when stored electronically (IRS: Recordkeeping).
3. Account Ledger / Summary sheet
Summarize receipts, payments, and net activity by account and month using the transactions table as the source. If you need formal double-entry records, financial statements, or accounting for inventory, payroll, fixed assets, loans, or accruals, get advice on an appropriate system rather than treating this summary as a full ledger.
Rank #2
- Neatly Track & Organize Your Finances: The accounting ledger book is here for you to stay on top of your spendings & income! Clearly & neatly structured, it offers ample space for all crucial information about checks, savings, bills & other expenses or income
- Perfect For Small Business Owners: Keep it simple, yet super effective - the undated income and expense log book is an absolute must-have among small business supplies! Register your financial data and use your debit & credit records to compile a trial balance
- Premium Style With A Sturdy Cover: With the 120-page finance tracker, you can manage your finances conveniently in one place. A solid cover, thick paper and a reliable ring binding ensure maximum durability
- Beautiful Modern Minimalistic Design: A visual highlight just like you can expect from ZICOTO! The sage green cover of the ledger book, look stunning with a modern golden floral on the front - makes bookkeeping simply beautiful!
- Super Handy - Always At Hand: Thanks to its practical size, the 8.6x6.1” ledger book fits into any bag easily and is therefore always by your side. Whether used as a checkbook register or to track other financial flow, with the log book you’ve got it all sorted!
4. Monthly Reconciliation sheet
For each statement period, record the statement opening and closing balances, outstanding deposits and payments, bank fees or corrections, adjusted balances, review date, and any unresolved difference. Keep a copy of the bank statement and a note explaining how differences were handled.
5. Evidence index
List or link the supporting records for transactions and organize files consistently—for example, by year and document type. The IRS gives invoices, receipts, deposit slips, canceled checks, sales slips, and account records as examples of supporting documents in Publication 583 (IRS Publication 583).
Enter transactions consistently
- Record activity promptly. Publication 583 says it is generally best to record transactions daily.
- Describe the source and business purpose. Identify where receipts came from and what an expense was for; keep personal and business activity separate, and use a dedicated business account where appropriate.
- Assign a category. Choose from a consistent account list rather than creating slightly different labels for the same type of activity.
- Attach or identify the evidence. Use a filename or location that lets you find the related invoice, receipt, deposit slip, or other record.
- Review the entry. Look for missing details, duplicate transactions, unusual amounts, and uncategorized items before closing the month.
- Back up and protect the workbook and evidence files. Electronic records must still provide a complete and accurate record that is accessible to the IRS; using Excel alone does not ensure that standard is met (IRS: Recordkeeping).
Calculate a running cash balance
With separate Receipt and Payment columns, calculate each row’s ending balance as the previous balance plus receipts minus payments:
Rank #3
- EASY TO MANAGE - Use this accounting ledger book to track your payments, deposits, and balances, and develop good bookkeeping habits to meet your financial goals.
- UNDATED ACCOUNT TRACK - Use a ledger book to record every expense you make no matter what day it starts. The accounting book is plenty of space to record each transaction you make, and state its number, date, description, account, payment or deposit amount, and total balance.
- HIGH QUALITY - The A5 expense tracker notebook is used to high quality 100gsm pure white paper, brown elastic band and a back pocket for extra space. A total of 64 sheets(128 pages), it comes with 3480 entry lines (29 lines per page, 60sheets/120pages), 1 page Year Overview, 7 lined notes pages.
- MANAGE YOUR FINANCES & SUCCEED - Use this business expense tracker notebook, You will be able to easily analyze your financial activities and quickly prepare accurate financial statements. Use your records to regularly assess your spending and income and find any unnecessary expenses you can cut to improve your financial performance.
- THE PERFECT GIFT - Use account ledger book for your personal or business finances, give it to your friends, colleagues as a gift for Birthday| Easter|Children's Day|Halloween|Thanksgiving|Christmas|Back to school and New Year's Day.
=prior_balance + receipt_cell - payment_cell
Replace the example references with the cells in your workbook. Put the opening balance in a clearly identified starting row or cell, and check that the formula uses the same sign convention as your entries. For example, if payments are already entered as negative amounts in a single Amount column, add that amount to the prior balance; do not subtract it a second time.
Free tools Windows power users keep installed
One-click scans. No signup required.
Excel formulas begin with = and can use cell references and functions such as SUM. Relative references adjust when a formula is copied; absolute references stay fixed. Excel tables can fill calculated-column formulas through the table, filter and sort rows, and provide a total row. The total row can use SUM or SUBTOTAL; SUBTOTAL can exclude filtered-out rows by default. See Microsoft’s overview of Excel tables and Microsoft’s guide to creating a simple formula.
Use a table total row or a summary formula to total receipts and payments for a period. Keep transfers, owner contributions, and owner withdrawals distinct from revenue and expenses. A bank deposit is not necessarily sales: it may include a loan, transfer, refund, or another non-sales item. Ask a qualified accountant if you are unsure how to classify a transaction.
Build the account and monthly summaries
Use the account/category and date fields in the transaction table to group activity by account and month. Show receipts, payments, and net activity separately so that a net figure does not obscure what moved through an account. You can use Excel table filters and total rows for a quick review, or create a separate summary with formulas that refer to the transaction table. If filtering the table, remember that a SUBTOTAL total can reflect the visible rows rather than every row.
Reconcile the cash book with your bank statement each month
The cash book and bank statement can differ temporarily because a deposit was made after the statement date, a check or payment has not cleared, or the bank has charged a fee. The IRS recommends reconciling the business checking account monthly and describes these types of differences in Publication 583 (IRS Publication 583).
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstall- Enter the statement period and its opening and closing balances on the reconciliation sheet.
- Match statement deposits and cleared payments against the corresponding transactions in Excel.
- List deposits not yet shown by the bank and outstanding checks or other payments.
- Record bank charges, bank errors, or book-entry errors, and make appropriate corrections in the workbook.
- Compare adjusted balances after valid timing items and corrections. Investigate any remaining difference rather than forcing the balances to match.
- Save the statement, note unresolved items and their disposition, and record the date the reconciliation was reviewed.
Do not silently overwrite an old entry to make a reconciliation work. Make an explained correction so another person can follow the record trail.
Best Value
- Refined Financial Management: Our ledger books for bookkeeping can be used to track personal bills and budgets and serve as book keeping log for small business.Helps you keep track of your expenses and income for effective financial planning.
- Adequate Ledger Entries: Dimensions are 8.4 x 6.1 inches, making it easy for you to take anywhere. This accounting ledger comes with 3304 entry spaces (120 pages) so you can record all your financial information in one place, with easier access to track transaction types and dates.
- Elegant & Exquisite Design: Our ledger notebook adopts a classic waterproof material cover, which is not easy to wear. Gold double spiral binding makes flipping through easy. This bookkeeping book is also designed with practical inner pockets and bookmark elastic bands.
- Flexible & Thick Paper: Our accounting book is made of 100gsm non-bleeding paper, perfect for fountain pens, ballpoint pens and other pen types. Convenient to write on, so you no longer have to worry about bleeding ink.
- Perfect For Gift Giving: As you would expect, the cover of the book keeping book is beautifully designed with gold foil lettering and floral patterns. Perfect as a gift for parents and friends, or as a business ledger for small business.
Know when Excel is not enough
For U.S. federal recordkeeping, the IRS generally lets a business choose a system suited to its activity as long as it clearly shows income and expenses; it does not prescribe one universal workbook layout. How long a particular document must be kept depends on the action, expense, or event it records, and employment-tax records have separate guidance. Check the applicable IRS rules rather than applying one retention period to every record (IRS: Recordkeeping).
A cash book may not cover the bookkeeping and reporting needs of a business with inventory, payroll, fixed assets and depreciation, sales tax, loans, accruals, multiple bank accounts, or formal financial-statement requirements. Seek professional accounting advice if you are unsure about your accounting method, tax treatment, or reporting obligations. IRS guidance cited here is U.S.-specific; businesses elsewhere should check local requirements.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →
