Reconcile Vendor Statements

Related Pages

Vendor Documents

AP Check Batches / Printing Checks from Nexsyis

 

The statement reconciliation feature is for gathering unpaid invoices so you can pay them, using the statement as the verification tool of what and how much is owed. You cannot reconcile invoices that are already paid.

 

Benefits of Nexsyis Vendor Statement Reconciliation

 

* You can reconcile to totals on each statement
* You can reconcile multiple months at the same time
* You can scan and attach the statement to the reconciling batch
* The Auto-Create process will do a lot of work for you by assigning invoices in the selected period to each statement
 
 

Reconcile Vendor Statements with Invoices Recorded in Nexsyis

Note: you must have APVendorClass Permissions to perform this task.

Below, we will be reconciling statements these 4 invoices for Sample Honda:

From the Accounting tab, select Reconcile Statement in the Accounts Payable group.

1. Locate the Vendor by ID or name.


2. In the Auto-Create Statements for a Period section, enter the details of the statement, the statement date (only 1 per vendor, per date, per location allowed), and the from and to dates the period covers

3. Click the Create Statements button in that window and Statement batches will be created for each unique Location Key (LK) for which an AP Invoice exists between the dates specified in (2) above, and the existing invoices will be assigned to those statements

4. Review each paper statement to ensure that it matches the totals of each batch (totals for each are under the Totals column in the list)

5. If the statement totals do not match, select the statement and click the Edit button to view invoices in that statement batch.

6. Select the invoice on the right and click the details button to open and correct.

7. Once your invoice total is correct, click the back arrow to go back to the statements screen.
8. If you've keyed any new invoices, you can click the Create Statements button again using the same statement date and it will create any missing statements and assign any unassigned invoices

9. When a statement is reconciled, select it in the list and click the Finalize Statement button to mark it finalized
10. You can link the Statement document to the Statement batch using the Imaging feature in Nexsyis. The "Vendor Statement (Statement)" document links to the Statement, while the "Vendor Statement (Vendor)" document is the document formerly known as Vendor Statement, which links to the Vendor record.
Once statements have been reconciled, you can now pay invoices.
 

 

Additional Notes 

 

* You can create an individual statement for one location using the Create Individual Statement panel. It will begin with a "0" total. You will need to Edit the batch, and move all invoices on the statement from the left to the right.

* You can delete a statement. Any invoices on that statement will move to unreconciled
* You can un-finalize a statement by checking the Show Finalized checkbox and selecting the statement line. Click the Un-Finalize button.
* When a statement is not finalized, only unpaid invoices are available for reconciling
* If you select a finalized statement, all Invoices will be displayed (paid or not)
 
 

 

 

 

© 2005 - 2025 ProProfs
-