EN
Marketplace

How Do You Choose Expense Tracking Software? A Guide to Categories, Recording Receipts and Invoices, Cash Flow, and Marketplace Expenses

How do you choose expense tracking software? Category structure, recording receipts and invoices, VAT logic, recurring expenses, a marketplace expense table, and a checklist.

Contents 11 sections
  1. What is expense tracking software, and how is it different from Excel?
  2. Which expense categories should be set up for business expense tracking?
  3. Which eight features should you look for when choosing expense management software?
  4. How are receipts and invoices recorded as expenses?
  5. How does the logic of VAT deduction affect expense records?
  6. How do you manage recurring expenses and due dates?
  7. How does expense tracking affect cash flow?
  8. How does a marketplace seller track commission, shipping, and advertising expenses separately?
  9. What are the most common mistakes when choosing expense tracking software?
  10. How do you track expenses with NetKasam?
  11. Frequently Asked Questions About Expense Tracking Software

In most businesses, expenses sit in three places at once: receipts in a drawer, the bank statement, and an Excel spreadsheet. At the end of the month, these three don't match; questions like whether the rent was paid, whether the shipping invoice had arrived, or which month an advertising expense should be recorded in take a week to sort out. The solution is usually to use expense tracking software; however, not every program does the same thing, and the choice is determined by the structure of your own expenses.

This guide doesn't explain the concept of expenses from scratch; for a general framework, see the articles how can you keep expenses under control in your company and what is expense management. Here we answer one question: which software should you choose for business expense tracking, and how should you use it? You'll find setting up expense categories, recording receipts and invoices, the logic of VAT deduction, recurring expenses, the effect on cash flow, and how a marketplace seller tracks commission, shipping, and advertising expenses separately, along with a sample monthly expense table. The sample figures are only to illustrate the method.

What is expense tracking software, and how is it different from Excel?

In short: Expense tracking software records and reports all of a business's spending with its category, amount, document, payment status, and due date. In Excel, you write each expense line by line yourself; in the software, an expense is automatically linked to cash and bank movements, cash flow, and reports.

The difference shows up most at the end of the month. In a spreadsheet, the "paid" status gets forgotten, the photo of the document ends up in another folder, and the same invoice is entered twice. In software, an expense record sits together with its document, its due date is visible if unpaid, and whoever entered it is shown on the record. That way, expenses become an up-to-date table every day rather than a pile gathered at month end.

If you're experiencing two of these signs, it's time to switch to software: some expenses still go unrecorded as receipts or out-of-pocket spending; you can't say how much of a burden each item brings; you remember a payment that's coming due only on the last day; employees report their spending by sending you messages.

Which expense categories should be set up for business expense tracking?

In short: Expense categories are set up according to the areas where the business actually spends money, and their number is kept manageable; for most small businesses, 8–12 categories are enough. Too few categories prevent distinctions, and too many increase recording errors.

Set up your category structure on paper before opening the software. Each category should answer a single question: "How much did we spend on this this month?" The table below is a sample starting structure; add to it or merge items to suit your business.

CategoryWhat goes in it?Why track it separately?
StaffSalaries, SGK, meals, transportation, bonusesUsually the largest item; personnel costs should be visible separately
Rent and utility billsRent, electricity, water, internet, phoneFixed and predictable; arrives on the same date every month
Marketplace commissions and service feesSales commission, service and transaction feesChanges with sales; a main item in the profit calculation
Shipping and packagingShipments, return shipping, boxes, tape, bagsIncreases with the number of orders; shows return volume
Advertising and marketingAd spend, campaigns, product photographyReturn is measurable; an item that can be scaled down or up
Software, accounting, and consultingSubscriptions, certified public accountant, e-invoice creditsA regular, recurring item
Bank and payment chargesBank transfer, EFT, POS, and virtual POS deductionsLooks small, adds up over the year
Other and unforeseenMinor repairs, refreshments, rare expensesIf it grows, it's time to open a new category

Two rules make things easier. First, an expense is entered in only one category; a record split across two categories distorts the report. Second, the "Other" item should remain a small part of the total; if it has grown, there's a category hiding inside it. If you want to use categories together with a budget, the term budget variance explains how to read the variance.

Which eight features should you look for when choosing expense management software?

In short: Look for eight features: category and expense slip structure, document attachment, payment status and due date tracking, reminders, expenses by person, cash and bank linkage, a cash flow view, and expense reports. Testing and scoring each one with your own last month's actual records makes the decision clear.

ScoringA weighted scoring formula for comparing expense tracking software
  1. Feature score = a grade between 0 and 5 that you give after testing with real records
  2. Weight = the importance of the feature for your business (1, 2, or 3)
  3. Weighted score = Feature score × Weight
  4. Total score = Sum of weighted scores ÷ (5 × sum of weights) × 100

In a business where employees incur many expenses, the weight of expenses by person may be 3; in a one-person business, 1.

The table below summarizes the eight features, the question to ask in a demo, and what a good answer looks like.

FeatureQuestion to askWhat does a good answer look like?
Expense slip and categoryCan I record an expense by assigning it to a category?Each expense slip is linked to a category, which can be changed later
Document attachmentCan I attach an image of the receipt or invoice to the record?The document stays inside the record and opens from the expense list
Payment status and due dateCan I see unpaid and future-dated expenses separately?The "to be paid" status and due date appear in the list and on the calendar
RemindersDo I get an alert for payments coming due?A notification or calendar entry before the due date
Expenses by personCan I report how much each employee has entered in expenses?A person is selected on the expense record and the report can be filtered by person
Cash and bank linkageIs an expense I pay deducted from the cash or bank account?The payment record automatically updates the relevant account and balance
Cash flowCan I plan and view income and expenses separately?Future payments are reflected in the cash flow view
ReportingCan I report expenses by category, period, and person?Filterable reports and export

One rule applies in a demo: take one of your real receipts and record it from start to finish. See how many clicks it takes to choose a category, attach the document, mark the payment status, and then find it in a report. A flow that takes longer than six steps is a flow that gets abandoned at month end.

How are receipts and invoices recorded as expenses?

In short: An expense record is kept together with its document: take the document, enter the date and amount, choose the category, mark the payment status, and attach an image of the document. An expense without a document is weak from both a tracking and an accounting perspective.

Recording flowAn expense document is recorded in six steps: receive, enter, categorize, pay, attach, report
  1. 01
    Receive the documentInvoice, retail sales receipt, cash register receipt, expense voucher, or bank receipt.
  2. 02
    Enter the date and amountIf the document date and payment date differ, note both.
  3. 03
    Choose the categoryOne category; if a split is needed, create separate records.
  4. 04
    Mark the payment statusPaid or to be paid; if to be paid, enter the due date.
  5. 05
    Attach an image of the documentA photo or file is attached to the record.
  6. 06
    Verify in the reportAt month end, compare category totals with the number of documents.

Which documents count as an expense document is often confused. For a general framework, see the term what is an expense document, and for points to watch when claiming business expenses, see the article what to watch for when claiming business expenses. For the document issued when you buy from a person who doesn't issue invoices, the article on the expense voucher (gider pusulası) points you to the right place. What to expect from the software is that it can keep all these documents in the same expense list, with the document type identified.

How does the logic of VAT deduction affect expense records?

In short: As a general rule, the VAT shown separately on the invoice for goods and services purchased for business activity can be deducted from the VAT calculated on sales. That's why the expense record needs to show the amount excluding VAT, the VAT, and the amount including VAT separately.

The logic is simple: the VAT you paid on purchases is deducted from the VAT you collected from customers on sales, and the difference is paid to the state. If you keep expense records only as a VAT-inclusive total, you have to recalculate the deductible VAT every period. Software that records the amount in three parts saves time when preparing the VAT return.

There are two points to watch. First, the document must be valid and must show a purchase related to your business. Second, the law limits the deduction of VAT on certain expenditures; which purchases fall within this scope depends on your business and the nature of the expenditure. Don't rely on guesswork when making this distinction; flag uncertain items in the software and clarify them with your certified public accountant. For the full invoice flow, also see the article how to choose free e-Invoice software.

How do you manage recurring expenses and due dates?

In short: Recurring expenses such as rent, subscriptions, salaries, and taxes arrive on the same date every month; recording them as future-dated with a "to be paid" status and setting up a reminder prevents delays and forgetting. A recurring expense shouldn't be a surprise; it should be visible on the calendar.

A three-minute check at the start of each month is enough: are the future-dated records for fixed expenses in place, which ones are due this week, and which subscription is no longer used? In NetKasam, when creating an expense slip, you can set the payment status to "to be paid" and create a future-dated record; the system alerts you on the due date. You can also create payment orders with the calendar feature.

If you pay by cheque and promissory note, tracking due dates is a separate task; for that, see the cheque and promissory note tracking page. If you want to track your deferred payables to suppliers through the current account, the article how to choose customer and supplier account tracking software is a useful complement.

How does expense tracking affect cash flow?

In short: If expense records are kept with their payment dates, you can see how much money will go out in the coming weeks; this is the foundation of a cash flow plan. A profitable business can also experience a cash crunch; the difference is created by the gap between expense due dates and collection due dates.

Two separate dates are tracked: the period the expense belongs to and the day the money goes out. An advertising expense is incurred in October and the card statement is paid in November; the profit calculation looks at October, the cash plan at November. If the expense management software lets you plan income and expenses separately, you can answer the question "what do I have, what will go out, what will come in" for the next four weeks on a single screen. For the logic of matching expense items with revenue, the term matching of revenues and expenses helps.

Recommended readingHow Do You Create a Fixed Expense and Payment Calendar? A Training on Fixed and Variable Expenses, Recording Payable Expenses, a Weekly Calendar, Cash Shortfalls, and Break-Even Revenue

How does a marketplace seller track commission, shipping, and advertising expenses separately?

In short: A marketplace seller tracks commission and service fees, shipping, and advertising in three separate categories and expresses each as a ratio of net sales. When these ratios rise, you can see which item is eroding profit.

Let's consider a sample business. In one month, it makes ₺200,000 in net sales excluding VAT, the cost of the products sold is ₺60,000, and the following operating expenses are incurred. The figures were chosen only to illustrate the method.

Expense item (monthly, excluding VAT)AmountRatio to net sales
Staff (salaries and SGK)45.000 ₺%22,5
Marketplace commissions and service fees24.000 ₺%12
Shipping and packaging (16,000 + 4,000)20.000 ₺%10
Advertising and marketing14.000 ₺%7
Rent and utility bills (18,000 + 2,500)20.500 ₺%10,25
Software, accounting, and bank charges (3,500 + 3,000)6.500 ₺%3,25
Other2.000 ₺%1
Total operating expenses132.000 ₺%66
BreakdownOf the sample business's ₺132,000 in monthly expenses, the largest shares go to staff and marketplace fees
  • Staff₺45,00034.1%
  • Marketplace commission and service₺24,00018.2%
  • Rent and bills₺20,50015.5%
  • Shipping and packaging₺20,00015.2%
  • Advertising and marketing₺14,00010.6%
  • Software and bank₺6,5004.9%
  • Other₺2,0001.5%

Prepared with sample values.

RatioEach expense item as a ratio of net sales: staff alone approaches a quarter of sales
  1. Staff22.50%
  2. Marketplace commission and service12.00%
  3. Rent and bills10.25%
  4. Shipping and packaging10.00%
  5. Advertising and marketing7.00%
  6. Software and bank3.25%
  7. Other1.00%

Prepared with sample values. Ratio = item amount ÷ net sales × 100 (net sales in the example: ₺200,000).

Now let's look step by step at the effect of these expenses on month-end profit. Product cost is a separate item; it comes from inventory and is a matter for inventory tracking rather than expense tracking, but it is read together in the profit calculation.

ChartFrom ₺200,000 in net sales to ₺8,000 in operating profit: how much does each expense group take?
  1. Net sales (excluding VAT)₺200,000
  2. Cost of products sold−₺60,000
  3. Gross profit₺140,000
  4. Marketplace commission and service−₺24,000
  5. Shipping and packaging−₺20,000
  6. Advertising and marketing−₺14,000
  7. After selling expenses₺82,000
  8. Personnel−₺45,000
  9. Rent and bills−₺20,500
  10. Software and bank−₺6,500
  11. Other−₺2,000
  12. Operating profit (before tax)₺8,000

Prepared with sample values. Income or corporate tax is not included in this calculation.

Takeaways from the exampleFour key numbers from the sample month
  • 66%operating expenses as a ratio of net sales
  • 30%product cost as a ratio of net sales
  • 4%remaining operating profit as a ratio of net sales
  • 29%combined share of marketplace, shipping, and advertising (₺58,000)

The table clearly shows one thing: 29% of sales, that is ₺58,000, goes to marketplace fees, shipping, and advertising. A business that doesn't track these three items separately just says "expenses are high"; one that does can tell in which month the shipping ratio rose and whether advertising is turning into sales. For calculating net profit per product, read how to calculate net profit on a marketplace; for how far your margin can hold up when discounting, how to offer discounts without losing money; and for the sales volume at which you start making a profit, how to calculate the break-even point.

What are the most common mistakes when choosing expense tracking software?

In short: The most common mistakes are opening too many categories, not attaching the document to the record, not marking the payment status, keeping expenses separate from the profit table, and gathering employee spending after the fact. The seven mistakes below explain most of the losses.

  1. Opening thirty categories. Choosing correctly during recording becomes harder, and "Other" swells anyway. Start with eight to twelve categories.
  2. Leaving the document for later. A receipt searched for at month end gets lost; attach the image at the time of recording.
  3. Leaving the payment status blank. If paid and payable expenses get mixed up, cash flow is misread.
  4. Burying VAT in the total. If you don't record the amount excluding VAT, the VAT, and the total separately, you need to recalculate every period.
  5. Lumping commission, shipping, and advertising into one item. You can't see which one is eroding profit.
  6. Gathering employee spending at month end. Forgotten receipts and undocumented spending pile up; the person who spends should record it.
  7. Not comparing expenses with revenue. An expense on its own says nothing; its ratio to net sales gives it meaning.

How do you track expenses with NetKasam?

In short: In NetKasam, expense tracking runs in the same panel as bookkeeping and e-Invoice: expense slips, payment status, document attachment, calendar and reminders, expenses by staff member, cash and bank records, and cash flow are all in one system. Bookkeeping is free.

With expense management, you can categorize your expenses, create expense slips, and track whether expenses have been paid. You can create future-dated expenses and get an alert on the payment date, attach documents to expense records, and match payment dates with the calendar. Employees can enter their own expenses from their mobile phone or computer and upload documents such as receipts and invoices to the system; you can report how much expense each staff member has created. For bank charges arising from collections or payments, the expense slip is created automatically by the system and posted to the relevant account. If you cancel an incorrect expense slip, the transaction's movement is updated with a reversing entry.

By planning income and expenses separately, you can manage your cash flow and run reports with this data. You track supplier payables with customer and supplier account tracking and issued and received documents with invoice tracking. To get to know the bookkeeping side, see the bookkeeping software page; for the scope and prices of marketplace and e-commerce integrations, see the pricing page. No credit card is required to sign up.

Frequently Asked Questions About Expense Tracking Software

How do you choose expense tracking software?

Expense slips and category structure, document attachment, payment status and due dates, reminders, expenses by person, cash and bank linkage, cash flow, and reporting features are tested with your last month's actual records and compared with a weighted score.

How many categories are enough for business expense tracking?

For most small businesses, eight to twelve categories are enough. Set up the categories on paper before entering them into the software, and keep the "Other" item to a small part of the total.

How do I add receipts and invoices to the software?

When creating an expense record, you enter the date, amount, and category and attach an image of the document to the record. In NetKasam, documents can be attached to expense records, and employees can upload receipts or invoices themselves.

Why is VAT kept separate in expense records?

Because, as a general rule, the VAT on goods and services purchased for business activity can be deducted from the VAT on sales, the amount excluding VAT, the VAT, and the total should appear separately. Clarify with your certified public accountant (mali müşavir) which expenditures' VAT is deductible.

Can I create future-dated expenses?

Yes. In NetKasam, when creating an expense slip, you can set the payment status to "to be paid" to create a record for a future date. The system alerts you on the date the payment is due.

Can my employees enter their own expenses?

Yes. In NetKasam, employees can enter their expenses into the system and upload documents from their mobile phone or computer. You can report how much expense each staff member has created.

How should a marketplace seller track expenses?

Commissions and service fees, shipping and packaging, and advertising are kept in separate categories, and each is expressed as a ratio of monthly net sales. An increase in the ratios shows which item is eroding profit.

Is the expense tracking software free?

In NetKasam, expense management is part of bookkeeping, and bookkeeping is free. What's paid are marketplace and e-commerce integrations; current scope and prices are on the pricing page.

The right expense tracking software is one that shows next month's payments in advance as accurately as it shows this month's spending. As a first step, write your categories on paper in eight to twelve items, enter ten of last month's receipts into a candidate program and test the document, payment status, and reporting flow; then create your first expense table by expressing commission, shipping, and advertising as ratios of net sales.

Bookkeeping Is Now Completely Free

Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.

Start FreeExpense Management

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools