Troubleshoot your payments import

The following topic explains common problems that you might encounter when importing payments and their solutions.

Want more help? Explore our knowledge base and get answers from other users by visiting the Sage Intacct Community. Find out how to sign up and get the most out of the Community.

Resolution: Make sure that your payment method is supported and that you match the payment method format in the notes.

Reason: A payment method might not be supported for a few reasons: 

  • The payment method is not supported for CSV import. These unsupported payment methods are online credit card and online ACH.

  • The payment method format does not match the required format for import. For example, an import can fail when you enter Check instead of Printed check.

Resolution: Make sure that the TRX_AMOUNTTOAPPLY amount and the TRANSACTION_NO amount due are equal. If there's an overpayment balance, the OVERPAYMENTAMOUNT and OVERPAYMENTLOCATIONID are required columns. The TRX_AMOUNTTOAPPLY and OVERPAYMENTAMOUNT need to equal the total due for the TRANSACTION_NO.

Resolution: Make sure that each payment row has a valid Customer ID.

Resolution: Make sure that each row has a valid TRANSACTION_NO that matches the invoice or adjustment number in Intacct.

Resolution: Make sure that each payment has fewer than 1,000 transaction lines in the TRX_AMOUNTTOAPPLY column, then try again.

Reason: You receive this error message when you try to import more than 1,000 transactions for a single payment. For example, you receive a payment and try to apply it to 1,005 invoices or adjustments.

Resolution: Make sure that the CSV file has fewer than 5,000 lines, then try again. If you need to import more than 5,000 lines, break it up and import multiple files.

Reason: You receive this error message when you try to import more than 5,000 payment lines in a single CSV file.