Your bank balance looks good, but you're not sure what you've made this month. You've got a mix of materials, software subscriptions, transportation, vendor payments and client-project costs. Bank transactions show where the money went, but you're not sure why.

Don't wait until you have last year's receipts in order to start tracking expenses from today. Assign each transaction a place, then go through older records month by month. The more you record at the time, the easier it is to understand expenses, locate evidence and make decisions later.

Separate business transactions

Have a separate business bank account and payment card if appropriate to your entity and location. This may save time looking for business transactions among personal transactions and make operating cash more visible. Try to minimize cash purchases that are harder to track.

For a mixed-use purchase, note both parts and the basis for allocation at the time of purchase. Don't put all credit card activity into operating expenses or leave the allocation to memory. Separate transfers, owners' contributions, reimbursements, refunds and owners' withdrawals rather than lumping them all together as income or expenses.

  • Use appropriate business payment accounts where possible.
  • Record mixed-use portions and their basis at purchase.
  • Separate transfers and owner funds from income and expenses.
  • Limit cash purchases that are hard to track.

Create useful expense categories

Good expense categories allow you to understand operations and prepare tax records. Begin with an appropriate chart of accounts and be consistent with names. Categories may include advertising, fees, insurance, office costs, professional services, rent, repairs, software, supplies, travel, utilities and vehicle expenses.

Group costs by expense type and put the vendor in another field. You don't need a different category for every vendor. Don't mix direct project costs with overhead. Define custom categories, and work out with the bookkeeper or tax professional how the accounts should meet current reporting requirements. Avoid leaving all reclassification until filing time.

  • Classify by expense type.
  • Record the vendor separately.
  • Differentiate direct job costs from overhead.
  • Define custom categories.
A business owner organizing receipts and expense records

Capture complete supporting documents

Scan paper receipts before they become illegible. Capture clear information about the vendor, date, items and amount. Hold on to original electronic files. Use filenames with a date, vendor or other consistent reference, linked to the entry's year and category so you can go from the record to the document.

U.S. IRS recordkeeping guidance identifies invoices, receipts, account statements and canceled checks among the documents supporting entries. Evidence should show the payee, amount, proof of payment, date incurred and business nature of the goods or services. It may take several documents; one receipt might not tell the whole story.

Use appropriate account security and backups for sensitive documents. The U.S. IRS states that electronic records follow the same general recordkeeping principles and requirements as paper records. Keep them readable, complete, secure and retrievable for the required period. Maintain originals when another rule or practical need requires it.

  • Payee and the date the transaction occurred
  • Item or service description
  • Amount and proof of payment
  • Business purpose and pertinent project or client

Reconcile and review every month

At month-end or shortly afterwards, match your books with all business bank accounts, cards and payment-platform records. Are the balances right? Look for missing or duplicate transactions, refunds, transfers, unusual charges and payments recorded in the wrong period. Write down questions with what you know while people can still recall the transaction.

Summarize spending, duplicate or unused subscriptions, and projects where spending exceeds estimates. Check them against the budget, previous periods and revenue. Watch for renewals, price increases, repeated rush charges, rising project costs and clients' overdue payments. Arrange the paperwork for handover to the accountant at the agreed time.

  • Match the accounts and statements.
  • Resolve missing and duplicate transactions.
  • Check category totals and operating cash.
  • Deliver organized records to the accountant on time.

Record the transaction and its purpose

A spreadsheet may be enough. Clearly show the date, vendor, amount, category, business purpose, payment account and a link or reference to supporting documents. Include payment status, and add currency and payment method as needed. If the cost is reimbursable, add the client or project and reimbursement status.

For paper bought for a client's proposal, write “client proposal printing” rather than just an amount. A September 22 stationery-shop purchase of 86 yuan could use reference EXP-0922-01. A separate September 22 parking payment of 18 yuan for a site measurement at a south-side store could use reference EXP-0922-02.

A receipt may state what you bought without naming the client, project or trip. Add the purpose while it's fresh. For an online subscription, hold on to the supplier's invoice or receipt. An account screenshot can support the record but might not be complete.

A bank record may indicate payment without explaining the purchase. A receipt may show the purchase without a payment record, leaving settlement unclear. Associate payment and purchase evidence with stable dates, numbers or links.

Separate several questions that are often mixed together

What's the expense? What's the project? Has it been paid? Will a client or employer reimburse it? Keep these questions separate. A travel expense could belong to a client project and still be waiting for reimbursement.

Don't substitute “reimbursable” for the actual type of cost, such as travel or materials. Keeping the facts separate lets you add up travel costs, project costs and reimbursements to be received without counting the transaction twice.

Use accounts and payment methods that make review easier

Using a business account helps you avoid mixing transactions, but it doesn't automatically explain an expense. Payment from a personal account doesn't make an actual business purchase a personal expense. Show the actual allocation basis for mixed use. The card used doesn't determine deductibility; the facts and applicable accounting and tax rules do.

One transaction might show up as a card purchase, part of the monthly statement and a reimbursement request. Connect these as different records of the same transaction without entering the expense three times. Track returns and refunds back to the purchase. Add explanations and evidence weekly and review accounts monthly, even when accounts are separate.

Include costs that do not arrive as a small receipt

Materials, subscriptions, equipment purchases, loan payments and owner withdrawals reduce the bank balance but might not all be the same kind of expense. Record the date, payee, amount and purpose, then classify them rather than treating every debit as an operating expense.

Payroll, contractor pay, insurance, rent, recurring software and equipment can involve large amounts without a small receipt every day. Hold on to invoices, agreements or payroll records. Don't add a summary on top of transactions already entered. Inventory and equipment may differ from everyday expenses. Keep purchase records and talk to the person responsible for the books instead of making a temporary guess a permanent category.

Rent and recurring subscriptions may be relatively stable in the short term. Materials, transportation and some labor might fluctuate with orders. Interest is part of borrowing costs. Equipment purchases and depreciation involve use across time periods, so the entire purchase amount is not automatically an expense of that month.

Review ongoing monthly amounts for rent and subscriptions and note any changes. Check increased material and freight costs as orders grow, and separate principal, interest and other charges within loan payments. Keep records of equipment purchases, use and later asset treatment, and identify true business costs in mixed payments. Record the date, purpose, evidence and notes daily without overcomplicating it. Classify consistently at month-end, separately from confirming deductibility and deduction timing.

Employee pay, employer taxes or benefits and contractor payments may need different treatment. Don't leave just a “labor” total without the people, period and payment basis. Check the applicable employment, payroll and tax rules.

Provide a consistent method for everyone to submit reimbursement claims. Record the submission date, purpose, evidence, approver and payment status so everyone knows how to submit and what has already been claimed. Avoid collecting the same evidence across multiple chats.

Reconcile regularly instead of rebuilding the year

Don't start from scratch at year-end. Review uncategorized transactions, incomplete paperwork and expenses waiting for reimbursement each week, then reconcile accounts monthly, or more often when transaction volume requires it. Keep outstanding questions visible with the evidence available.

Start with current expenses, then work back through bank statements and other evidence by month. List transactions with missing information separately; don't make up a purpose or amount. Recording costs and determining tax deductibility are separate tasks. Use the facts, then apply the relevant accounting and tax rules. Don't omit a cost just because you're unsure how it should be handled.

Use the records to improve spending decisions

Compare the same periods and distinguish a one-off equipment purchase from recurring monthly expenses. Don't assume all spending must stop because one category has increased.

Use records to inform what you keep, renegotiate or change. If categories take too much time to maintain without helping decisions, they may be too detailed. Maintain enough information to explain the business and support the required records.

Get entries, evidence, account statements and previous submissions ready for tax time or the agreed accountant handover. With ongoing records, this means organizing existing information rather than investigating every payment again.

Questions you may still have

Can I track business expenses in a spreadsheet?

Yes, if each record clearly shows the transaction date, vendor, amount, expense category, business purpose, payment account and a link or reference to evidence of the expense.

How often should expenses be recorded?

Keep evidence while the transaction is fresh, then review records weekly and reconcile all business bank, card and payment-platform accounts monthly. Increase the frequency when needed.

Do electronic receipts count as records?

The U.S. IRS indicates that electronic and paper records follow the same basic recordkeeping principles and requirements. Keep them readable, complete, secure and available for the required period. Retain originals where required.

Sources