About this series:
In addition to our other coverage, Murph is starting a new series of “How to” articles related to various ERPs. In today's edition, he is looking at his second “How to Acumatica.” Some of these will be short, others long, depending on the particular ERP and feature Murph decides to highlight.
Read away this week, but if you want more of Murph's "How To" in the near future, you are going to need to head over to our 'Be Insightful' Premium Content to keep up with all the future editions.
Acumatica - Match Bank Receipt Transaction to a Debit Adjustment
Acumatica ERP users running 2024 R2 can match a bank receipt transaction to a debit adjustment on the Match to Invoices tab of the Process Bank Transactions form. Auto-matching can also be used for this purpose.
To match a bank receipt transaction to a debit adjustment, a user should perform the following steps:
1) From the Import Bank Transactions window, upload the bank statement file for the appropriate cash account and period using the Upload File tab.
2) After uploading the bank statement file, click Process on the form toolbar.
3) On the Process Bank Transactions window, select the bank receipt transaction in the left pane and
4) Go to the Match to Invoices tab; Acumatica loads any documents that match the selected bank transaction.
5) Select the Matched check box for the debit adjustment to match it to the bank transaction as shown with ‘callout 5’ on the following screenshot.
Source: Adapted by Insightful Accountant from Acumatica media source content
6) Click Process; Acumatica will create a refund for each bank receipt transaction matched as a debit adjustment.
7) The Ext.Ref.Nbr. of the bank receipt transaction gets posted to the Payment Ref. field in the Checks and Payments window, as shown below.
Source: Acumatica media source content
How easy can it be? I bet, in less than a minute's read, you've learned how to post a difficult bank transaction from a bank download in a entirely different General Ledger than you typically use.
Disclosures:
Acumatica, as used herein, refers to one or more registered trademarks of Acumatica, Inc., a privately held, multi-national corporation headquartered in Kirkland, WA (USA). Since 2019, Acumatica has been held by the private equity firm EQT of Stockholm, Stockholms Lan, Sweden.
Acumatica Cloud ERP is a comprehensive business management solution that was born in the cloud and built for more connected, collaborative ways of working. Designed explicitly to enable small and mid-market companies to thrive in today’s digital economy, Acumatica’s flexible solution, customer-friendly business practices, and industry-specific functionality help growing businesses adapt to fast-moving markets and take control of their future.
Any other trade names used herein, including those of the sponsors (vendors) featured within this article, refer to products that may be registered, trademarked, or otherwise held by their respective owners; they are referenced for informational and educational purposes only.
Feature product-related content derived from Acumatica media source materials. Content derived from Acumatica sources is published by Insightful Accountant for informational and educational purposes only.
This is an editorial feature, not sponsored content. No company or other person mentioned in this article has paid Insightful Accountant or the author any remuneration to be the subject of this feature. The article is provided solely for informational and educational purposes.
The publication of this article should not be interpreted as an endorsement by either the author or Insightful Accountant.