There is a limitation with Sage Intacct where the Document Number field on a bill cannot be overwritten once it has been populated.

When a payment is processed through the bank plugin, the document number of the bill is populated with an alphanumeric Reference ID. This field is usually where you would expect to find the Check Number.

As part of the bank plugin onboarding process, either you or someone from your organization has supplied a check number range. When processing a Check Print payment, the next sequential check number is retrieved from the designated range and communicated back to Intacct. It's important to note that Intacct does not permit the override of the Document Number field once it has been populated with the alphanumeric Reference ID. Consequently, the check number is filled in under the Bank tab within a custom field named Transaction ID on the bill.

Because the alphanumeric Reference ID is populated instead of the Check Number, you may discover that during reconciliation, you can only see the Reference ID on the Intacct side and the actual Check Number on the bank side. 

To help with reconciliation, you can create a custom view in Intacct to display the corresponding Check number for each alphanumeric Reference ID.

To create this report, please follow the below steps:

Select the columns you wish to see on the custom view. Be sure to select 

After saving the view, you can filter for 'CHECK' under the Payment Method column to isolate bills that have been paid through Check Print via your bank plugin.

Voiding & Repaying Bills (Intacct)

Check Number Limitations (Intacct)

YourBank

MyBank

Enabling Grouped Bills & Remittance Emails (Intacct)

Payment Methods (Intacct)

Commerce Bank

Welcome

Untitled

Pre-Onboarding Checklist (NetSuite)

Installation and Set-up

Post-Onboarding Checklist (NetSuite)

Configuration

Vendor Bank Details

Temp

Vendor Payables

Information Reporting

Remittance Advice (NetSuite)

Features

FAQ (NetSuite)

NACHA 2021 FAQ

Failed Bills

Managing Security Tokens (NetSuite)

Troubleshooting

Sandbox Checklist (NetSuite)

Release Notes (NetSuite)

Entity Bank Detail Release Notes

Release Notes

Netsuite

Pre-Onboarding Checklist (Intacct) (cloned)

Post-Onboarding Checklist (Intacct)

Plugin Configuration

Bill Payments (Intacct)

Balances & Transactions

Remittance Advice (Intacct)

Sandbox Testing (Intacct)

Release Notes (Intacct)

Intacct

Pre-Onboarding Checklist (BC365)

Installation

Post-Onboarding Checklist (BC365)

Remittance Advice (BC365)

FAQ (BC365)

Sandbox Checklist (BC365)

Release Notes (BC365)

Pre-Onboarding Checklist (QBO)

Installation & Set-up

Post-Onboarding Checklist (QBO)

Setting Up Multi-Factor Authentication

Re-Authentication (QBO)

Payments

Remittance Advice

FAQ (QBO)

Release Notes (QBO)

Xero

Approval Portal

ACH Requirements

Payment Requirements

Feature Requests

Contact Us