Prior Outstanding csv file upload bank rec

Created by Liam Trimble, Modified on Mon, 15 Jul at 1:24 PM by Laura Gannon-Berg

Q:  How do I enter my Excel file of Prior Outstanding into the Soluno Bank Rec? 

A:  Two files need to be created.  

 

One for Outstanding Cheques and one for Outstanding Receipts.  

 

Soluno will need the Prior Outstanding List to be in “.CSV” format.  

 

The column headings for Prior Outstanding - Previous Cheques “csv” file must be as follows:   

 

A screenshot of a computer 
Description automatically generated


The column headings for Prior Outstanding - Previous Receipts “csv” file must be as follows: 

 

A screenshot of a calculator 
Description automatically generated


To load the File into Soluno - Go to BANK ADMIN icon, then click on the FEEDS AND RECONCILIATION tab.  Display the Bank Account by choosing the bank from the dropdown list and then pressing the small “Play” button to the right.  Adjust the dates as required and then press the “Submit” button at the bottom left of the screen. 

 

A screenshot of a computer 
Description automatically generated


From the “Feeds and Reconciliation” tab click on the “Prior Outstanding” submenu item. 

 

A screenshot of a computer 
Description automatically generated

 

A screenshot of a computer 
Description automatically generated


Along the bottom middle area click on the “Previous Cheques” or the “Previous Receipts” buttons.  Drag and drop a file in the “Drop Import File Here” box, or click in the box to display a list of available files. 

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article