Split a mid-period invoice into 2 monthly revenue amounts

Key takeaways

Record the service start date, end date, and invoice total.
Count service days consistently at both boundaries.
Keep a written rounding rule for similar invoices.
Ask an accountant how to treat advance payments.

Why a mid-period invoice causes trouble

Consider a business that bills in neat chunks. A cleaning contract runs January 1 through January 31, and the whole amount belongs to one month. Those invoices are easy to file.

Many services do not work that way. A client signs up on January 15 and pays for a month of service that ends on February 14. A maintenance plan begins in the middle of a week that spans a month end. The invoice covers one continuous stretch of time, but that stretch crosses a month end, so the revenue-recognition approach illustrated here assigns income to each service month.

This post explains how to split that kind of invoice into two monthly revenue amounts. It covers what to write on the invoice, how to decide the split, and how to check your work. It is written for owners who send invoices and bookkeepers who record them. The method is general. Your accounting software, your accountant, and the standard your business follows may call for something more specific, so treat this as a practical starting point rather than a substitute for professional advice.

Why the split matters

Your invoice tells the client what they owe and when it is due. Your revenue reports tell you how the business performed in each month. A single invoice can serve both purposes only if its dates are clear.

When an invoice covers a period that crosses a month end, a simple approach puts the whole amount into the month the invoice was created. That can make one month look strong and the next look weak, even when the work was spread evenly.

Accounting software has rules for this. The Zoho help page describes revenue recognition as a way to keep reports accurate and compliant with accounting standards such as ASC 606 and IFRS 15. It explains that these standards "define how and when a business should recognise its revenue" ( Zoho, "Revenue Recognition | Help | Zoho Books"). You do not need to memorise either standard to use the basic idea. Income should follow the period in which the service is delivered, not simply the day the money arrives or the invoice is written.

Even if your business does not follow those standards formally, the habit helps. Splitting the amount by service period gives you monthly numbers that match the work you did. It also makes sudden changes in your reports easier to explain to a lender, a partner, or your future self.

Decide what the invoice covers

Before you touch any dates, write down three facts about the service:

The start date. The first day the client receives the service.
The end date. The last day covered by this invoice.
The total amount. What the client is paying for the whole period.

Be precise about the start and end dates. A service from January 15 to February 14 is a different thing from one that runs to February 15. Use full calendar dates on the invoice so nobody has to guess.

Also decide whether the price is a single fee for the whole period or a monthly rate that happens to fall across two months. The split works differently in each case:

A single fee for the whole period. Divide the total across the days in the period, then assign each part to the month where those days fall.
A monthly rate that crosses a boundary. Calculate a daily or partial-month rate, then apply it to the days in each month.

Both approaches produce two amounts, one for each month, that add up exactly to the invoice total.

Set the service dates on the invoice

The invoice should show two things clearly: when it was issued, and what period it covers. These are not the same. The invoice date is the day you create and send the document. The service period is the range of days the work covers.

The Odoo documentation notes that "Invoice Date and Bill Date are pre-filled when encoding a transaction" ( Odoo, "Accounting and Invoicing — Odoo 19.0 documentation"). The software fills in the date for you, so check that default every time. If you issue an invoice early in January for service that starts on January 15, the invoice date and the service start date differ, and your records should reflect both.

On the invoice itself, a line item might read:

> Monthly service, January 15, 2026 to February 14, 2026. Total: $100.

A line like this does three jobs. It tells the client what they are paying for. It gives you the period you need to split. And it gives your bookkeeper one place to look when they check the revenue later.

Avoid vague wording such as "January service" or "this month's work" when the service crosses a month end. Those phrases leave the boundary unclear, and they make it harder to answer a client's question about a statement line. For repeat billing, also check your recurring invoice dates.

Do the split by day

One way to split a period across two months is to count days. Find how many days of the service fall in the first month and how many fall in the second, then divide the total in the same proportion.

Here is the method in plain steps:

Count the days in the service period that fall in the first month. Include both the start day and the end day.
Count the days that fall in the second month.
Add those two counts. The total should equal the number of days in the full period. If it does not, recount.
Divide the invoice total by the total number of days to get a daily amount.
Multiply the daily amount by the days in the first month. That is your first revenue amount.
Multiply the daily amount by the days in the second month. That is your second revenue amount.
Check that the two amounts add back to the invoice total.

The last check matters most. Rounding can leave a few cents unaccounted for. If the two monthly amounts do not add to the original total, adjust the later amount so the sum matches exactly. A report that is off by a cent causes more confusion than a rounding choice you have written down and applied consistently.

Keep the daily rate to a sensible number of decimal places, and round in the same way across the whole business. Choose a rule once, write it in your bookkeeping notes, and apply it to every split invoice.

Some businesses split by full days of service rather than calendar days. Others split by working days, which suits a service delivered only on weekdays. Either choice can be reasonable. What matters is that you pick one method, use it for every similar invoice, and can explain it if asked.

A worked example with two months

The Zoho Books help page publishes a clear example of a single invoice recognised across two months. It describes a subscription invoice worth $100 for a service period of January 15, 2026 to February 14, 2026 ( Zoho, "Revenue Recognition | Help | Zoho Books").

The service period runs across the end of January. The page describes the split in two steps. The first step "recognises revenue earned from January 15 to January 31." The second "recognises the remaining revenue earned from February 1 to February 14." The resulting amounts are $54.84 in January and $45.16 in February ( Zoho, "Revenue Recognition | Help | Zoho Books").

The January portion covers the 15th through the 31st, and the February portion covers the 1st through the 14th. The boundary falls between January 31 and February 1.

The same page also shows a related case with the same two amounts, this time recognised as $54.84 in February and $45.16 in March ( Zoho, "Revenue Recognition | Help | Zoho Books"). The amounts follow the service period, not the calendar month where the invoice happens to fall.

To test your own process, set up this $100 invoice in your system and check that your monthly split matches $54.84 and $45.16. If it does, your method is working. If not, find the source of the difference before you apply the method to real invoices.

A second example: a long annual fee

Splitting a fee across month ends is not limited to short invoices. The same Zoho page gives a second example involving a longer contract: "a subscription worth $1200" that "is created from 1 January 2022 to 31 December 2022" ( Zoho, "Revenue Recognition | Help | Zoho Books").

Here the period is a full year, so the same logic applies across twelve months instead of two. You would not write twelve separate invoices for one contract unless your billing model calls for it. Instead, keep a schedule that shows how much of the total belongs to each month, and let your revenue report draw from that schedule.

For a bookkeeper, the schedule is the most useful tool in this situation. It lists each month, the service days in that month, the amount recognised, and a running total that ends at the invoice value. When the schedule ends at exactly the amount billed, it reconciles to the invoice total; that alone does not confirm the accounting treatment.

Use the bank and the reports together

Your revenue report is not the only place the money shows up. The payment appears in your bank account and, if you use a payment processor, in its records. Those can look different from your revenue split, and that is expected. A client may pay the full amount in January for service that runs into February. The cash arrives once, and the revenue is recognised in two parts.

The Stripe documentation describes its balance summary report this way: "It includes all transactions and payouts that occurred during the selected period" ( Stripe Documentation, "Balance summary report | Stripe Documentation"). That record is useful for reconciling payments, but it tracks cash movement, not service delivery. Keep those two jobs separate. Use the guide to reconcile bank statements in software when checking the payment side.

When you reconcile, check three things:

The cash received matches the amount the client paid.
The revenue recognised across your months adds back to the invoice total.
Your accountant has confirmed how to record money received for service not yet delivered under your accounting basis.

If a client pays in advance for service that starts next month, track the payment separately from the service schedule. Confirm the appropriate account and recognition treatment with your accountant before recording that advance.

Common mistakes to avoid

Several errors come up again and again when people split a mid-period invoice.

Using the invoice date instead of the service dates. Odoo pre-fills the invoice date, and it is easy to accept it without thinking. If the service started before the invoice was created, the revenue may belong to an earlier month. Always check the service dates first.

Counting the days wrong at the boundaries. Off-by-one errors can cause a mismatch. Decide whether the start day and the end day both count, then apply that rule every time.

Splitting the wrong total. Some people split the monthly rate instead of the invoice total. If the monthly amounts do not sum to the invoice total, something is wrong. The final check catches this.

Rounding each month separately. Rounding January and February independently can leave the two amounts short of the total.

Forgetting a cancellation or early end. If a client cancels or the service is cut short, the amount recognised so far may need to change. Note the adjustment on the invoice or in your schedule so it stays visible.

Mixing up cash and revenue. Receiving a payment does not mean you have earned the income. Keep the two records apart.

Set up a repeatable process

A one-time split is manageable. A dozen split invoices a month needs rules. A simple setup works for many small businesses.

First, write down your standard: the method for splitting by day, the rounding rule, and how you count the start and end dates. Keep these in one place where your bookkeeper can find them.

Second, make the service period a required field. Do not allow a mid-period invoice to be created without a start date and an end date. Check whether your accounting system supports a service-period field or note.

Third, build a spreadsheet with a row for each month, the number of days, the daily rate, and the amount. Copy it for each new contract, enter the dates and total, and check the total at the bottom every time.

Fourth, review the schedule at each month end. Compare the revenue recognised with the service actually delivered. If a client paused a service or received extra work, adjust the schedule and note why. Then check that bank deposits, processor reports, and revenue schedules tell a consistent story. Explain any differences rather than ignoring them.

Try a split today

Take your next invoice that crosses a month end and create a draft schedule using the steps above. Compare it with the invoice before changing your records, and note any accounting questions for review.

Questions to take to an accountant

When should an accountant review the split?

Talk to a qualified accountant when a simple day-count split may not fit your contract or reporting requirements. Some situations go beyond a simple day-count split. Talk to a qualified accountant if any of these apply:

Your contracts include variable fees, usage charges, or milestone payments.
Your work is hard to measure by day, such as a project with uneven progress.
A client pays a large amount far in advance, or a refund policy affects how much of a payment is earned.
You are preparing statements for a lender, an investor, or a tax filing that must meet a specific standard.
Your software's default settings do not match the way your business earns its money.

An accountant can tell you which standard applies to your business and how to document your method.

Does matching the invoice total prove the treatment is correct?

No, matching the total checks the arithmetic, while the recognition method still needs to fit the service and accounting basis.

What should you bring to the review?

Bring the invoice, service dates, payment record, and draft revenue schedule so your accountant can review the split.