These are two separate menu choices in the Accounting application Main Menu > Financials > Accounting > Accounts Payable > Banking.

The operation of these two applications is identical.

There are two functions of these applications:

• To produce a consolidated banking value for the bank reconciliation program.

• To optionally produce a banking supplement report.

Whether either of these applications or processes needs to be run is entirely dependent on how the user company's bank processes multiple item deposits or withdrawals.

Creditors Banking

Creditors are slightly different from Debtors in that cheques sent to suppliers are presented to the bank as individual transactions.

Where electronic payment transactions (EFT) are being used, some banks output the total amount of the EFT banking as one line on the bank statement, whereas others will output the value of the individual transactions.

If the EFT total is the value output on the bank statement, then creditors banking will need to be run to consolidate the EFT payments in Tourplan NX to one line in the bank reconciliation.

Create a Banking Transaction

The Creditors Banking program are accessed from the Accounting application. For this example, Creditors Banking is being used.

On entry to the Banking Transaction program, there are From/To date filter selection fields to find and scroll existing bankings. They default to the current date.

1. From the Home menu, select Financials > Accounting > Accounts ReceivablePayable > Banking.

   1. Click the Home Menu to expand it:

      

   2. Click the Financials menu option to expand it:

      

   3. Click Accounting to go to the Accounting menu to expand it:

      

   4. Click Accounts Receivable/Payable to go to the Accounts Receivable/Payable menu to expand it:

      

   5. Click Banking to go to the Banking Transaction (Accounting filter) screen:

      

2. Select Banking Date From/To, select the required Currency and click Filter.

   

3. Click New Banking.

   

4. The Transaction Selections screen will display with the Filter tab open.
5. On the Transaction Selection Filter Tab screen, enter the required detail to set the Transaction search criteria. Selections can be filtered by:
   1. Date Entered From/To
   2. Account Name & Number
   3. Currency
   4. Transaction Date From/To

6. Within the Transaction Selection Filter Tab screen, select the required payment type(s) by checking all, or specific Payment Type. If G.L. Banking Transactions are to be included in the banking, select Transactions From General Ledger.

7. When selections are complete, click either the Search Button or the Results Tab to view the selected transactions.

   

8. In the Results Tab screen, Click the Select All button to select all displayed transactions, or individually select them using the Check Boxes next to the Code column. To Unselect all transactions, click the Unselect All button to select individual transactions.

   

9. Click Save Banking to keep the changes.

   

10. The save banking Entry screen displays. Enter a Banking Date, enter a Reference to identify the banking and select the Banking Completed checkbox if the banking is completed.

    

11. Click Save Banking to keep the changes.

    

12. Click Exit to discard any changes.

    

Filter Screen

Banking Date From/To

Set the date filters to search for transactions to be included in the banking..

Currency (Drop-down)

Select the currency matching the transactions to be included in the banking.

Transaction Selection Screen

• Filter Tab

The Transaction Selection screen displays with the filter tab highlighted.



Date Entered From/To (Date)

Enter the Entered Date range that will encompass the transactions to be included in the banking.

Transaction Date From/To (Date)

Ensure that a transaction date range is entered that is wide enough to include the transaction dates entered in the fields above.

Account Name/Number (Drop-downs)

Selecting the (physical) Bank Account that the banking is to be applied against from the drop-down will also select the Account Number. Selecting the Account Number will also select the Account Name.

NOTE: The physical bank details have specific Tourplan NX G.L. Bank Account numbers attached to them (see Bank Reconciliation Setup), and only transactions with those G.L. Bank Account numbers will be selected.

Payment Types Section (Creditors)/Receipt Types (Debtors) (Multi Select List Box)

By default the system includes all payment/receipt types. They can be limited by checking only the types to be included in the banking.

Transactions From Section (Check-boxes)

In Creditors banking, Creditors is checked by default; in Debtors banking, Debtors is checked by default. In addition, transactions that have been entered via GL Journals to the Tourplan GL Account(s) attached to the bank account can also be included if necessary by checking the General Ledger check-box.

• Results Tab

  

Banking Date (Date)

Enter the date on which the transactions were banked. This date will display in the Bank Reconciliation program.

Banking Reference (Chr, 20)

Enter a reference for the banking. This reference will display in the Bank Reconciliation program.

Banking Completed (Check-box)

If unchecked this banking will be left open for transactions to be added or deleted. Once checked, the banking can not be amended.