Northstar - Syncing Payment Data

Modified on Thu, 09 Feb 2023 at 04:27 PM

To sync Payment data go to the Account Payable module in Northstar and Select the Vendor Payment History report.

Here select the Payment Date From and Payment Date To. Typically our clients would complete this process weekly and select the dates from the past week's worth of payments they've just completed but which are not showing in Beanworks yet.

(Please note if this is the first time you're creating the payment file, select the From date as a couple of weeks before your implementation start date.)

When selecting your payments, choose only Payment Type Check, and if you are using the Beanworks Payments Module to send your payments choose Payment Type "Beanworks". 

Once the dates are set change the Output Format to Beanworks (CSV) and Generate Report.

A file called 09-Payments.csv will download in your browser. Move the file from this location into the SFTP (e.g WinSCP). After 3-5 minutes (file size dependant) the file will process and you'll find the payment information available in Beanworks matched to the invoices.

**NB** Do Not Open the file in Excel and Save. Excel will change the formatting of the file such as removing leading zeros and change date formats, this will cause payment data to match incorrectly or not process into Beanworks at all.

If you haven't set up WinSCP yet, please see the following guide: Setting Up WinSCP
If this is your first time transferring files, please see the following guide: How to transfer files using WinSCP

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons

Feedback sent

We appreciate your effort and will try to fix the article