Monthly expense tracker: manage recurring costs by month

An online store pays for the same things every month: the platform, the warehouse, the carrier, ad accounts, software and the accountant. Each one bills on its own day and emails an invoice in its own format, so the real question at the start of each month is not what you spent but what is still missing. A monthly expense tracker answers it. You describe your recurring costs once, the tracker opens a fresh list every month, and you see at a glance which expenses already have an invoice. This guide explains how to set one up, how a month moves from pending to sent, and how StoreChart handles each step.

What a monthly expense tracker does

A good tracker has three jobs:

• Remember what repeats: the list of regular vendors, so nobody rebuilds it from the bank statement.
• Show what is missing: each expense is marked as waiting, collected or sent.
• Close the month: every document ends up in one place, ready for your accountant.

A spreadsheet can do the first job and only the first. It does not collect the documents, and it does not tell you that the carrier's invoice has not arrived yet.

Recurring and one-time expenses

The distinction matters because it decides what carries forward.

• Recurring: appears in every new month automatically, with its category, currency and billing day.
• One-time: belongs to a single month, such as an annual insurance payment.
• Promoted later: a one-time expense can be added to the recurring list from its row, and removed again without deleting anything.

Removing an expense from the recurring list stops it carrying forward. The row, its invoices and earlier months stay as they were.

Setting up the recurring list

Start in the expenses module, in the month you are in now.

1. Open last month's business card statement and your inbox.
2. List every charge that repeats monthly.
3. For each, set a name, a vendor, a category and a currency.
4. Add the billing day, the day the invoice usually appears.
5. If the invoice arrives by email, add the sender addresses or a subject keyword, or add the vendor by picking one real invoice from your mailbox and letting the system learn it.

If a vendor sends two invoices a month, set the number it should expect. The expense counts as collected only when all of them have arrived. For the full collection setup, see the guide to automatic invoice collection.

Categories that make totals useful

A category turns a pile of invoices into a picture. Built-in categories cover rent, shipping, accounting, software and marketing, and you can add your own, such as legal fees. Keep the list short: with a dozen categories the overview stays readable at a glance, while forty make every total a guess. The same categories appear in the spend overview, where each month is split by category and the vendors that cost the most are listed first.

How each month works

Every month opens with the recurring list, and each row carries a status:

• Pending: no invoice yet.
• Collected: an invoice was found or uploaded.
• Sent to accountant: the invoice was included in an email to your accountant.
• Marked done: you closed it by hand, for tasks and special cases.
• Skipped: left out of the month, and out of the progress count.

At the top, the tracker shows a progress bar, for example 15 of 18 collected, along with totals for collected and sent. You can add a short note to any row, search the mailbox for only the rows you select, or send only some of them to your accountant.

Editing without rewriting history

A tracker is only trustworthy if last quarter does not change when you edit today's settings. The rule is simple:

• Current month: a change applies from now on and carries to months that open later.
• Past month: a change touches that month only.
• Already sent: editing a row never changes what your accountant received.

A row whose invoice has already gone to your accountant is protected from bulk deletion.

Expenses that don't arrive by email

Not every cost has an email invoice. Choose the kind of row that fits:

• Email expense: collected automatically from Gmail.
• External expense: an ad platform or a supplier who never emails. Upload the document each month.
• Monthly task: a recurring chore with no amount and no invoice, which you mark done yourself.

Paper invoices work the same way: upload a photo or a PDF and the amount, VAT and date are read for you.

Example: closing a month with 20 expenses

Illustrative only. On the 4th the tracker shows 16 of 20 expenses collected, and four are still pending:

1. A vendor that posts invoices: the owner uploads the file by hand.
2. A vendor with a new sender address: the address is updated on the list and a search runs for that month.
3. An ad platform with no email invoice: it is already an external expense, so the owner uploads the monthly document.
4. A vendor that has not billed yet: left pending until the next scan.

Once the last three are in, the month's invoices go to the accountant on the day set in the settings.

The figures in this article's examples are illustrative only and do not reflect actual customer data.

From expenses to operating profit

The recurring expenses you record in the tracker are also the base of the profit and loss statement. When all of the month's invoices have been collected, the expenses come off gross profit and what remains is the operating profit of the month. When one or more invoices are still missing, the statement marks the profit as provisional, because expenses that were not collected are left out and the profit looks higher than it is. That is why an orderly month-end is not only your accountant's concern: it is the condition for reading the right number.

The statement covers whole months, quarters or years. A month that was never opened in the tracker is not treated as a month with no expenses, and the statement says so. The full explanation of the statement is in the profit and loss statement guide.

Common mistakes

• Starting with every vendor. Begin with the ten largest and add the rest as they appear.
• Changing a past month to fix the future. Edit the current month instead.
• Treating a total as proof. Check the amount and VAT that were read against the invoice, as with any automatic reading.
• Forgetting the tax side. The tracker collects documents. It is not accounting software: it does not issue invoices or file VAT returns.

Summary: a list that renews itself

A monthly expense tracker is a recurring list, a status for each row and a day on which the month closes. Keep the list short at first, correct only the current month and send your accountant the whole set at once. Recurring costs also feed the operating profit in your profit reports; for the bigger picture see calculating real profitability. The number of invoices you can store depends on your plan; see pricing.