Account balances using date ranges: what if the transaction date does not match the financial period?

Created by Harry Lewis, Modified on Tue, 16 Jul at 9:34 AM by Gabriel Michaud

Applies to:

  • Velixo NX
  • Velixo Classic
  • Acumatica, MYOB Acumatica, Cegid XRP Flex


Acumatica allows a transaction from a specific date to be posted to a different financial period.


This is particularly useful when creating year-to-date (YTD), month-to-date (MTD), or quarter-to-date (QTD) reports.


When calculating account balances using dates instead of financial periods, Velixo does NOT include those transactions which are within the date range but have been posted to a different period.



Let's assume the following three transactions have been posted to account 11000:





May 5, 2021



May 6, 2021



May 7, 2021



If we were to use the ACCOUNTTURNOVER function to report the account turnover for May 5, 2021 through May 7, 2021...




The results would be $100.00 (the amount of the transaction from May 6, which was posted to period 05-2021).


In this way, the transactions from May 5 and May 7 affect the balances in ONLY the financial periods to which they were posted (04-2021 and 06-2021, respectively).

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article