I am not a certified public accountant, but I have an accounting degree. After the bookkeeper left, I am in the process of cleaning up the company's books. As for QuickBooks Online (QBO), I consider myself fairly familiar with it, at least at the day-to-day operational level.

Now I have a specific issue: Suppose I receive an invoice on May 5, with a service period of April 28 to May 4. If I enter this invoice on May 5, can QBO automatically allocate 3/7 of it to April? Or do I have to do it manually through a Journal Entry?

Similarly, if I receive a payment on May 5 for the same period, can QBO automatically attribute 3/7 of this income to April without using a journal entry?

In short, the core question is: Does QBO have the ability to automatically split cross-month transactions proportionally by date into different accounting periods, or must such operations rely on manual intervention?

From accounting principles, revenue and expenses should be recognized on an accrual basis, meaning they are recorded based on the service period rather than the payment or receipt date. Therefore, for the week of service from April 28 to May 4, the portion from April 28 to 30 (3 days in total) should be recorded in April, and the portion from May 1 to 4 (4 days in total) should be recorded in May.

However, QBO's standard invoice and payment entry interfaces typically default to recording the entire transaction in the accounting period of the entry date. The system does not provide a built-in option to automatically split amounts based on the service start and end dates. Therefore, to accurately reflect cross-month attribution, users often need to use one of the following methods:

  • Manually create a journal entry to adjust part of the amount from May to April;
  • When entering the invoice or payment, directly split it into two transactions, each corresponding to a different period;
  • Use a third-party app or the project accounting feature in QBO Advanced (if available) to automatically allocate.

For payments, the situation is similar. When QBO records a payment, it typically applies the amount to outstanding invoices, but it does not automatically split income by service period. If the payment corresponds to cross-month services and there is no corresponding invoice, manual adjustment is needed.

In summary, unless using specific plugins or customized settings, QBO does not by default provide a function to automatically allocate cross-month amounts by day. Therefore, for the situation you describe, the safest approach is still to manually prepare journal entries to ensure financial statements accurately reflect income and expenses for each period.

If you want to simplify the process, you might consider clearly noting the service period when entering the invoice and explaining the allocation ratio in the notes, to facilitate future audits or adjustments. Additionally, it is advisable to consult an accountant familiar with QBO to confirm whether there is a more efficient automated solution suitable for your specific business scenario.