Report - Reconciled Transactions

Q:  Where can I see if the transaction is reconciled or not?

Answer:  3 Options  

Option 1:  Bank Reconciliation Report

BANK ADMIN -> FEEDS AND RECONCILATIONS tab

1.  Choose the Account from the dropdown list;

2   Press the "Play" button to load the existing dates.

The closed Bank Reconciliation periods will be in the section "Previous Periods" (highlighted in red).

Click on the PDF version of the Bank Rec to display the details of the "cleared in/out" and the "outstanding in/out".

Option 2:  Client Ledger

CONTACTS AND FILES -> FILES tab

Display the File with the Transaction.  Click on the "Ledger" sub-menu to view the "Client Ledger".

On the Client Ledger it will show as - CLR - if the transaction has been cleared on the Bank Rec and - OUT - if the transaction is still Outstanding.

Option 3:  Bank Register Report

(***Note:  for more detail instructions on how to Modify Report Layouts please refer to the document "Customize Reports" or contact Soluno Support)

REPORTS -> BANKING -> OPERATING tab (or TRUST tab)

Modify the Bank Register Report.  Click on the "Manage Layouts" button at the bottom right of the screen.

Click on the "Copy" icon to the right of the "Register" report layout.  Edit the copy of the layout using the "Pencil" icon.

 Click "Next" through the next few screens until the "Operating Bank Entries" screen is visible. 

Scroll down to the bottom of the list and click on the "Cleared on Bank Rec" button.

Click "Next" through the next few screens until a "Save" button is available.  Press "Save".

Press "Close" button on the "Manage Layouts" small screen.

The Customized Report has been created.  Create a View for the Report.

Click on "Save View" at the bottom right of the screen.

A small screen will pop-up.  Name the "View" a different name than the default name.  The Description will appear at the top of the Report.  Choose the "Register Copy" as the Layout (from the dropdown list).  Click on the button "Make the view public".  

Press the "OK" button.

Run the Report "registerclr".

There will now be a checkmark beside the entry on the report list if the transaction has been cleared on the Bank Rec.

-

-

-

Optional:

***Note:  this could have been done the first time.  

Give the "Cleared on Bank Rec" column a title.  

Position the checkmark at the start of the first line.

Change the Title on the report.

Edit the copy of the register report again (Manage Reports, edit "Register Copy", click "Next", "Next" "Next" to the "Operating Bank Entries" screen.  

Click in the "Title" column and type a short title, press tab, click in the "Row" column and change the value to 1, press tab, click in the "Order" Column and change the value to 1.  

It will then look like below. 

Then press "Next" button until the "Save" is available.  Press "Save".

Close the "Manage Reports" screen.

Now, click on the "Save View" button.

Edit the Description Line so the title of the report is "Bank Rec Cleared Indicator".

Press "Ok".

The checkmark on the report will now show-up at the beginning of the line beside the transaction and there will be a title on the column.  As well, the title at the top is "Bank Rec Cleared Indicator".