Skip to main content
Question

Duplicate payment while in migration mode.

  • March 3, 2026
  • 3 replies
  • 31 views

Hello,

 

I am requesting assistance on an AP issue that is currently preventing us from closing the month.

For background, we recently transitioned from our old accounting software to Acumatica. During the migration phase, I processed several checks outside of the old accounting system. I tracked paid invoices manually in Excel and issued checks accordingly.

 

Once we fully transitioned into Acumatica, I began entering backlog payables, clearing checks, and processing current activity. During this process, I inadvertently issued a check to a vendor for an invoice that had already been paid during the migration period.

 

In January, we received a refund check from the vendor indicating that the December payment was a duplicate. The original invoice was paid in November, and the duplicate payment was processed in December. The November invoice and check have already been properly cleared.

 

My question is: what is the correct way to clear the duplicate check in Acumatica without inflating the vendors payables. 

 

I would prefer not to create a placeholder or “fake” bill simply to offset the duplicate payment. Is there a recommended method that would properly resolve this in AP without inflating the vendor payables?

Thank you in advance for your assistance.

 

3 replies

Yasas Withanage
Acumatica Employee
Forum|alt.badge.img+5

Hello ​@amelendez 

To get a clear understanding of this issue,

Was this duplicate payment created under the migration mode or not?


  • Author
  • Freshman I
  • March 3, 2026

@YasasWithanage76 - 

To rephrase my question: I processed both checks outside of the system during the migration period, and neither was recorded in Acumatica at that time. After the migration, the original invoice and its corresponding payment were properly recorded in Acumatica. However, the duplicate check has not been recorded in the Acumatica.

We later received a refund check from the vendor indicating that one of the invoices included in the duplicate payment had already been paid. The duplicate check also covered another invoice.

Given this scenario, how would you recommend processing this properly in Acumatica?


Laura03
Captain II
Forum|alt.badge.img+20
  • Captain II
  • March 4, 2026

Hello,

Don’t worry:  Mistake + Adjustment = Accounting. 😉  Here is one suggestion for recording an adjustment to the errant transactions.

  1. Enter a duplicate Bill as a Credit Adjustment. I suggest Credit Adjustment because it will stand out as a document that increases the amount owed to a Vendor without being a Bill.
  • The purpose of this Credit Adjustment is to allow you to record the check in step 2 properly, because I am thinking it cleared your bank and therefore should be recorded.
  • Add a note to this Credit Memo indicating which bill was paid twice. Include a note that your vendor refunded over-payment on their Check #### on MM/DD/YYYY and their Refund of over-payment was recorded via GL in Step 3. 
  • This Credit Adjustment will Credit AP and Debit “Something”. Note which account was used as the Debit, because you will need it in step 3.
  1. Enter the Payment of Duplicate Bill recorded as a Credit Adjustment in step 1 and “another invoice” that was covered by the same payment. The duplicate check is now correctly recorded and may be cleared on the Bank Reconciliation Statement.
  1. Enter the vendor’s Refund check via Journal Transaction with Debit to the Cash Account where you deposited the refund check and credit to the same “Something” account that was Debited in Step 1. 

I hope this helps you. 

 

Laura