Is there a simple template or checklist for tracking business expenses?

When is a template and checklist enough?

IRS Publication 583, Starting a Business and Keeping Records, says that except in a few cases the law does not require any specific kind of records, and that you can choose any recordkeeping system suited to your business that clearly shows your income and expenses. It adds that specific recordkeeping rules apply to travel, transportation and gift expenses.

In practice, a manual sheet keeps up while all of these hold:

• Volume. You can enter each expense within a day and finish the monthly statement match in one sitting, before the next statements arrive.
• Accounts. Spending runs through few enough accounts, cards and cash funds that you can pull and match every statement yourself each month.
• Categories. The categories your books already use cover every row.
• Documentation. Spending that needs more than a general row, such as travel, vehicle use or client meals, gets its dedicated record or added detail.

Decide which role the sheet plays:

• Book of record. If the sheet is the only structured record of the spending, it must be complete and defensible on its own.
• Feeder. If it feeds books kept elsewhere, it must reconcile with them, as Publication 583 requires of computerized records, and the main risk is double counting: where the books already hold the expense, from a bank feed or a bill entered on arrival, match the row to that entry rather than posting it again.

Publication 583 says that under the cash method you usually deduct or capitalize expenses in the year you pay them, and under an accrual method in the year you incur them, whether or not you pay them that year. The sheet records spending as it is paid, so on an accrual method unpaid bills need their own record, and a paid bill's row is marked against that bill so the expense counts once. On the cash method, total each year by the Date paid column; on an accrual method, by the Date column, with unpaid bills in their own record.

What columns does the template need?

The IRS page "What kind of records should I keep" says your supporting documents should identify the payee, the amount paid, proof of payment, the date incurred, and a description of the item or service that shows the amount was for a business expense. The same page notes that a combination of documents may be needed to cover all the elements. Publication 583 says a bank or card statement can prove payment only if it is highly legible and shows the amount, the payee's name and the date it posted (for a card, the transaction date; for a check, also the check number); where a line does not name the payee, file the payment confirmation under the row's Ref too. Build the columns from the IRS page's list, plus a few working ones:

Never stop at payee and amount. The IRS page's list includes a description that shows the amount was for a business expense, so the purpose goes on the row; without it, a row also cannot be categorized or explained later. Publication 583 adds that proof of payment of an amount, by itself, does not establish you are entitled to a tax deduction, so also keep the sales slip or invoice showing you incurred the cost.

Does the sheet replace the receipts?

No. The IRS page "What kind of records should I keep" says your recordkeeping system should include a summary of your business transactions; the sheet is the expense side of that summary, and the documents stay behind it. The same page says your books must show your gross income as well as your deductions and credits, so an expense sheet alone does not meet that; recording income is a separate question. Publication 583 says it is important to keep supporting documents because they support the entries in your books and on your tax return, and to keep them in an orderly fashion and in a safe place.

Tie each row to its document by writing the row's Ref on the paper receipt, or naming the scanned or emailed copy with it, and filing documents in Ref order by month. Any row then leads to one document, and any document to one row. Publication 583 says a computerized system's records must provide enough detail to identify the underlying source documents.

If you scan receipts and want to discard the paper, Publication 583 sets these conditions: the electronic storage system must index, store, preserve, retrieve and reproduce the records in legible format; it must provide a complete and accurate record of your data that is accessible to the IRS; and the paper originals may be destroyed only once the system has been tested to establish that they are being reproduced in compliance with IRS requirements and procedures are established to ensure continued compliance. Publication 583 points to Revenue Procedure 97-22 for the details. Until all of that holds, keep the paper. How long to keep both is a separate question.

What does a filled-in template look like?

Here is March for a small design studio:

Each row points somewhere different:

• The supply-store receipt photo is saved as 2026-03-001.
• The emailed hosting invoice is saved as 2026-03-002, and the bank line shows the amount, the hosting company's name and the date the debit posted, so it can serve as proof of payment.
• The cash purchase has no statement, so the slip stapled to its receipt is the proof and the cash count with the slip check is the test.
• The hotel row points to trip record T-03 for the travel details. Its charge posted after March's statement closed, so the row is carried; when the charge appears on April's statement, the match is recorded on April's sheet against 2026-03-004, and March's locked copy stays as it was.

What checklist keeps the sheet current?

Publication 583 advises recording expenses when they occur, says it is generally best to record transactions daily, and says you should reconcile your checking account each month. Run these steps in order:

A statement line nobody recognizes does not wait for step 5: raise it with the bank or card issuer the day you find it, put the date and the issuer's reference on the open-items list, and finish the test; step 5 clears it only when the issuer has answered. If someone else keeps the sheet, the owner runs step 4 from their own bank and card logins, never from copies the keeper supplies.

Why should the categories match your books?

Publication 583's example single-entry system shows why: frequent expenses have their own headings across its disbursements journal, and an annual summary of the monthly expense totals provides the final amounts to enter on the tax return. A tracker feeds that chain only if its categories are the ones the books use. Invented categories, such as "shop stuff", must be re-coded row by row before posting, which wastes the time the sheet was meant to save. Copy the list from your books, adding any new category there first. If the sheet is your only record, use categories whose totals carry to the expense lines of your return, as in Publication 583's example. Which categories to use is its own question.

Which format fits: a paper log, a spreadsheet or a checklist on existing software?

The IRS page "What kind of records should I keep" says an electronic system you choose should meet the same basic recordkeeping principles. In practice, not by IRS rule, the formats compare like this:

How do you keep the sheet from being quietly changed or lost?

Add these controls:

• One keeper. One named person enters and edits rows; anyone else hands in documents, not edits.

• No silent rewrites. After a month's statement test, save it as a locked copy and leave it unchanged. Correct a closed month with a new dated row naming the row it corrects. In a paper log, strike through with one line, initial and date it, and never remove pages.

  If someone other than you keeps the sheet, the keeper sends you each closed month's locked copy at step 6 and you store it where the keeper cannot change it; if a closed month is questioned, compare against your copy.

• Backup. The IRS revenue procedure on automated records, Revenue Procedure 98-25, lists recommended records management practices that include creating back-up copies, selecting an offsite storage location and testing to confirm records integrity. Keep one copy offsite, away from where the computer is, including the saved receipt photos and emailed invoices, and at each close check that the offsite copy opens.

• The finished sheet is a record. Publication 583 says that with a computerized system you must be able to produce sufficient legible records to support and verify entries made on your return and determine your correct tax liability, that the machine-sensible records must reconcile with your books and return, and that you must keep all machine-sensible records and a complete description of the computerized portion of your system.

  Keep the file and, with it, a written description covering what Publication 583 lists: how an expense moves from capture to close (steps 1 to 6), the checks that keep it accurate (the statement test, the cash count and the slip check), the controls on changes (one keeper, locked monthly copies, dated correction rows), and the category list with what each category holds. For a paper log, keep the book.

Do not fill the sheet from memory weeks later. Publication 463, on travel, gift and transportation records, says to record an expense's elements at or near the time of the expense, and that a timely kept record has more value than a statement prepared later, when there is generally a lack of accurate recall.

How do you find expenses that never reached the sheet?

An omission cannot be seen from inside the sheet, so start outside it, from every line on every bank and card statement for the period. Publication 583 says that when you receive your bank statement, you should make sure the statement, your checkbook and your books agree. A statement line with no row is a missing expense unless it is one of three things: a payment of a card balance or a refill of the cash fund, whose spending is already on the card and slip rows; a transfer between your own accounts; or the late posting of a row carried from an earlier month. Mark those and move on; for any other line you recognize, add the row and get the document. Then check the other way: a card- or bank-paid row with no statement line is a late posting, a duplicate or an error. If you write checks, Publication 583's example journal lists and accounts for every prenumbered check number; do the same, voided checks included.

For cash, the check is the cash itself. Publication 583 describes a petty cash fund in which the unspent cash plus the amounts on the petty cash slips should equal the fund's fixed amount. Count it at every monthly test; if someone else holds the fund, the owner does the count. Then check the slips against the sheet: every slip number since the last count appears on a cash row, and the slips add up to the cash rows. A slip with no row is a missing expense.

Which expenses need more than a general row?

Publication 463 says that if you deduct travel, gift or transportation expenses, you must be able to prove certain elements of the expense. It says to keep documentary evidence that, together with your log or similar record, supports each element, and that you must generally provide a written statement of the business purpose. Those elements go beyond a general row, so for trips, vehicle use and gifts the row carries the amount and points to the dedicated record, such as a trip record or mileage log, which holds the rest. Building those records is a separate topic. Publication 463's recordkeeping rules also cover business meals and treat the business relationship of your guests as an element, so a client meal's row names who attended and that relationship in its purpose.

What changes when you pay cash or others spend for the business?

Cash. With no statement behind it, the sheet becomes the primary record rather than a summary of another: get a receipt every time, write the row the same day and note the slip number. If you cannot get a receipt, Publication 583 says to make an adequate explanation in your records at the time of payment: write the row as you pay, with who was paid, what for and why, and note that no receipt was available. Publication 583 says each time you make a payment from a petty cash fund, you should make out a petty cash slip and attach it to your receipt as proof of payment. How to keep records of cash purchases with no statement behind them, including cash spent without a fund, is a separate question.

Others who spend. Fill the Submitted by column and check each person at the monthly test: every line on the statement of a card someone else holds, pulled by the owner, must match a row with its document. Out-of-pocket spending people hand in has no outside record behind it, so the check confirms only that each claim has its document and elements, not that nothing was left out. Collecting receipts from staff and reimbursing them is a separate process.

When have you outgrown the template, and what carries forward?

These signs mean the manual sheet is no longer keeping up:

• The monthly test no longer finishes before the next statements arrive.
• Spending runs through more accounts or cards than you pull and match each month.
• Several people spend, and per-person checks pile up.
• Documents regularly cannot be found from their Ref.
• Capture runs days or weeks behind, so rows are written from memory.

If you change method, carry these forward:

• The closed, locked monthly sheets and their documents, in Ref order
• The Ref scheme and the category list, so old and new records line up
• The open-items list
• For each account, the closing date of the last statement fully tested

Change over at that tested closing date and count every expense once. Old rows stay in the old sheet, including any awaiting their statement line, and a later statement line matching an old row is not entered again. For that year, totals come from both records; on an accrual method, unpaid bills move with their bill record.