Skip to main content
Answer

Transactions Post-Dated October are being picked up in September BAS - why?

  • October 24, 2023
  • 8 replies
  • 129 views
M
Freshman II

Issue is that a handful of AP Bill transactions are appearing incorrectly in the September BAS when they should be appearing in the October BAS. 

Example: Transaction itself was created in the system in September 2023, dated 04/08/23 but post dated 04-2024. 

 

 GL Register Detail for this transaction confirms the From-To period as 04-2024.

 

However, when running the report “Tax Details by GL Account by Period” this transaction is appearing and the Tax Period shows as 03-2024.

My question is why is this transaction appearing on this report as post period 03-2024? Where is it picking up the post period date from? I have checked the Financials Tab and batch details but all showing as 04-2024 for October.

Best answer by MindaS

Hi Mari,

 

Yes, the issue was due to the ‘Define Tax Period by End Date of Financial Period’ checkbox under the Tax Agency tab of the ATO Supplier card being unticked which was causing the issue. 
 

The Acumatica Wiki Help definition states the below (which is a little unclear), however I did some testing and can confirm that with the checkbox ticked it then picked up the document and included the figures within the correct financial period when creating the BAS report.

 


 

Laura03

8 replies

Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • October 24, 2023

Hello,

Is it possible that the Tax Periods are different from the fiscal periods in your tenant? Please look at Tax Agency settings of Tax Agency Vendor. In this case, the client reports to the Tax Agency twice per year, so there are only two tax periods in a year:

 

~ Laura Barber, WM Synergy
Chris Hackett
M
Freshman II
  • MindaS
  • Author
  • Freshman II
  • October 24, 2023

Hi Laura,

Thank you for your response. It appears that the Tax Agency Settings and Tax Periods do both match as Tax Period Type Monthly.

However, I did notice from your screenshot that ‘Define Tax Period by End Date of Financial Period’ is checked and this clients is not - could this be why?

 

Laura03
Laura03
Captain II
Forum|alt.badge.img+19
  • Laura03
  • Captain II
  • October 24, 2023

Hi,

I notice the first date of your tax year is 1/7/2023. What is the first date of your fiscal year? Could they be off by a few days, causing some documents to fall into different tax months versus GL posting months?

Laura

~ Laura Barber, WM Synergy
M
Freshman II
  • MindaS
  • Author
  • Freshman II
  • October 24, 2023

Hi Laura,

 It looks like the dates also match up here as 1/07/2023.

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • November 30, 2023

Hi @MindaS were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
M
Freshman I

Hi Minda!

Did you find a solution for your issue? I have similar issue where journal is clearly in period 04 in GL, but in Tax Transaction Fin Period (not Tax period) is showing is 01.
Thanks,

Mari

M
Freshman II
  • MindaS
  • Author
  • Freshman II
  • Answer
  • November 11, 2024

Hi Mari,

 

Yes, the issue was due to the ‘Define Tax Period by End Date of Financial Period’ checkbox under the Tax Agency tab of the ATO Supplier card being unticked which was causing the issue. 
 

The Acumatica Wiki Help definition states the below (which is a little unclear), however I did some testing and can confirm that with the checkbox ticked it then picked up the document and included the figures within the correct financial period when creating the BAS report.

 


 

Laura03
Chris Hackett
M
Freshman I

Thanks for replying. In my case the tickbox was ticked and still the Fin Period in taxes module is not correct. I havent even run Prepare Tax yet, so no Tax periods.
I think its something to do with the fact its a credit of an earlier period invoice and imported record, somehow has got corrupted. Thanks again for coming back to me. 

Chris Hackett
M
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved