Bank accounts are a special type of GL account in the system.
Table of Contents
| Table of Contents |
|---|
Setting up Bank Accounts
Bank Accounts require a GL Account first, then define the bank details (BSB and Account number and related cards) on Host Company
For foreign currency bank accounts see Foreign Currency Transactions (fx)#BankAccounts
Configure the definition of the bank branches
Admin > Financials >
...
If you already have GL accounts setup as bank accounts
...
Setting up a new GL account as a Bank Account on Host Company
Reference the account in the bank account configuration 
- see Chart of Accounts to add GL accounts
...
| Note |
|---|
Note that once transactions have been entered to the bank account you cannot change the GL account |
...
Setup a Credit Account as a Liability - Credit accounts are a liability for your business
...
Assigning Credit cards on Accounts to people and Assets
Then you can assign cards that operate on the account to people (expenses) or Assets
...
Enter an opening balance for the bank account
An opening balance is simply a journal - one side is the current bank (or credit account) balance - the other side is normally formation assets or an account chosen by your accountant
Fuel Cards
Fuel cards are a Merchant Account - ie not a bank account - but a company you need to pay.
Create the Merchant Account on the Host company
Link the Fuel Card to the Asset
When the Fuel Statement Arrives
Note if you have Branches and Departments defined they will default from the Asset.
And the Asset will be linked to the $ and L from the line on the creditor Invoice
Credit Card Payments using Credit Card Terminals
When a bank provides Credit Card Terminals for processing transactions
Setup the bank Account Details
Select Payment Method EFTPOS (terminal) - then machine. Bank will default from terminal
| Note |
|---|
This is the only way a payment can be added to the batch for that terminal Reversal of Payment Journals will be added to the batch (Status - Create a Reversal) |
Payment Batch from EFTPOS Terminal Transactions (per terminal)
- When a payment is created
- if no batch exists for the Terminal / date / cutoff time combination - a new one is created
- if a batch exists then the payment will be added to it
| Note |
|---|
Batches will be closed every day by the system |
The batch is cleared in the bank account using the normal method - see Creating and Managing Bank Accounts
Credit Card Payments using credit card gateways like Eway
Register
- When you register with a credit card gateway - they will ask you for your bank details - and the bank will provide you with a merchant number that gets passed with the transaction information to identify the bank accounts to be impacted by the credit card transaction.
- When our system takes a credit card payment - the system passes your merchant number along with the transaction to the gateway and gets a response.
- Every response is logged and you will see the result on the transaction you are actioning (sales order, booking etc).
Indicate supported credit cards to limits the options users have on payment
Indicate the credit cards you support
The eway Merchant Number to pass through
Using eWay as an example: When you register with eWay - they ask for the bank details they are to put money into. Then they provide you with a Merchant ID number. Place this number in the Merchant ID field for that bank account. When the system takes a credit card transaction it looks for the bank account to use and the merchant ID to pass to eWay.
| Note |
|---|
Note you need the Secure Feature of "CreditCardProcessing" to be a non- zero value on one of your roles in order to see this field. Do not allow many people to see this field |
Payments are batched by eway
Multiple payments per day are deposited in your bank - not every transaction
- eWay will not send you a transaction for every individual transaction - they will instead send a lump of money 2x per day based on your overall transactions.
- So we need to group together all the transactions eWay has told us have been successful into a single $ value that we expect to see go into your bank.
- For this reason we batch together all credit card transactions into a "Batch" using the cut-off times told to us by eWay.
Clearing CC Batches in Bank Statement
- Although the payments are grouped together - we have found that the credit card gateways frequently send a different $ amount to what we would expect based on the payments sent to them.
- Reasons for this include - fees they may take out, charges they may add, reversals from failures of payment and other reasons.
- So - when you look at the bank reconciliation we have a list of the expected total from the Credit Card Gateway (the batch total) that you can see.
- If the amount they put into your bank is the same as we expected - simply right click and "clear all in batch" on the batch - and it will tick all transactions as included in the statement.
If the amount they deposited is not the same - you will have to go through the statement they provided and tick off individual transactions on the bank statement so you know which transactions have cleared.
Payments from/to Debtors and Payments to/from Creditors and bank accounts
When you have entered an invoice you want a payment to reference
When doing a Creditor Payment, Creditor Refund, Debtor Payment or Debtor Refund - you can select the bank account when you do the transaction - and that will place the transaction in the reconciliation screen for that bank account
When you do not want to enter an invoice - you just want to record a payment
| Note |
|---|
Normally you will want to enter all invoices into the system for record keeping reasons. DO NOT use this transaction and also enter an invoice - it will be double counting |
Use "Supplier Payment (No Invoice)" or "Customer Payment (No Invoice)" to create the transaction - referencing the bank account
Cash Batches
| Note |
|---|
If your business is collecting cash while delivering products on Waybills - review Working with Waybills |
Cash Batches are used when Cash is Collected by Sales Reps, Delivery Drivers and Bus Drivers
They count the cash in the batch as they drop it off.
Do a second count of each cash batch to confirm the amounts.
Group together multiple amounts of cash into a single bank deposit.
Capture the cash transaction
Sales Reps, Delivery Drivers and Bus Drivers are collecting cash during a day of driving around visiting customers.
- The cash they collect is grouped into a batch to be counted at the end of the day. This is known as a "Cash Batch"
- They may also spend some of this cash as they go - to wash the car, parking or other items. This is known as a "Spend Money" - cash was used.
- If they purchase items using a credit card (for example a fuel card) this is not included in the daily batch and is not a spend money as no cash was spent.
Cash payments may be recorded in a number of ways by drivers
If your business manages orders
- As a cash payment of a sales order or booking - from the sales order screen
As a cash payment not linked to a sales order - simply a cash collection from a debtor they visited from the debtor or in the driver portal.
If your business manages bookings
- The bus drivers portal as they drive
As a cash payment for a booking in the driver portal or entered later once they have returned.
The cash payment will default to their batch for the day
Cash Counting by drivers
Count the Cash taken during a number of days - Drop at office
At the end of the day the cash needs to be counted by the driver and will include
Cash total to count = Cash collected - cash spent (Spend Money Transactions Only).
The driver will do a first count of the cash and the cash batch will move to "Counted" status - note that the counted cash may not match the expected cash.
Then batch can then be counted by a second person and multiple batches banked in a single banking deposit.
Count the Cash taken over a number of days - Driver Deposit to the bank
If the driver is depositing the cash to the bank - the batch will be closed and a journal created to the bank for the amount deposited
Once the cash is dropped off to the office - second cash count
The office will do a second count of the cash - noting any discrepancies as an adjustment journal
Office does a second count and moves the batch to locked status
Group multiple cash counts into a single amount to deposit to the bank
Depositing cash into the bank - adding multiple amounts of cash into a total to take to the bank
After second counting a number of batches - the batches can be grouped together into a bank deposit
The batch will then have a reference on it to the journal that links it to the bank statement
| Note |
|---|
The Banking Batches Screen Consolidates this view into a single screen
|
How does the cash deposited appear in the bank statement
Cash batches appear as a single journal line in the bank statement ( A yellow General Journal) as all the cash was deposited as a single cash amount
Reconciling the bank statement
Getting ready to reconcile transactions
Reconciling the bank statement is a process of confirming each of the transactions you expect to have appeared are there and creating other transactions that you did not record in your business system. When you tick the box in the S column you are confirming that you have seen that transaction in the bank statement.
Choose the bank account
The Reconciliation screen will then open with the last reconciled date
Put in the date of the statement that you have in front of you - this is the date you are reconciling to
Enter the Statement Balance. The variance will populate showing how much $ transactions you have to find and tick as reconciled
Note that the transactions listed will be any transactions prior to the Reconciliation date that have not yet been reconciled.
Reconciling individual transactions
Next you need to look through your bank statement to find transactions to clear. Normally you have a printed out statement and you tick off each transaction as you find it.
It can help to untick the "presented" list - this makes it easier to find the transactions you have not yet cleared. As you clear transactions you can refresh and they will hide.
The bank reconciliation shows some transactions that are part of a credit card batch (see credit card section above in this document) - If the amount we say should be there is the same as in the bank statement you can clear these using a rightclick.
Reconciling Credit Card Batches Batches
The bottom RHS of the screen has a list of batches. A batch is a group of transactions. As you can see all the individual transactions are still visible in the bank statement - this is because it is common that what we expect and what is paid to you will often be different - because of fees, bounced transactions and other reasons. You can quickly clear all in batch using a right click if the values match. Otherwise you will need to use the credit card statement to clear them independently.
Enter Bank Fees
This is a good time to enter any bank fees that you find when looking at your credit card gateway trading statement
Remember that this is a grid like anywhere else in the system - so you can filter the transactions (CNTRL F) or top LHS of grid for filter - it will filter using any information in the grid
Filtering the transaction list
using letters
Filtering using numbers
Review of past reconciliations including the PDF report
At any time you can print a preview of the reconciliation report using the print button.
When you have completed the reconciliation (Reconcile Now) button all the transactions in the system that have been marked as reconciled will be locked and cannot be changed.
To view the report for any reconciliation - the current screen will then show all the transactions for that reconciliation (locked).
To view the report use the print screen - or the link to the saved report.
This is what the report looks like
| Note |
|---|
The saved report shows exactly the situation at the time of doing the bank Req - there are two numbers that may now be different...  When viewing a closed bank Req - the unpresented values are live values (not saved ones). Hence they will show you if any transactions prior to the reconcilation date have STILL not been cleared. The saved report shows accurately at the time of doing the bank req:
The Bank Balance is often not the same as the Balance sheet balance - due to un-presented transactions.
The numbers on the saved reports are expected to vary with the balance sheet balance at the date - this is best illustrated with an example:
|
Deleting Bank Reconcilations
- Go to Bank Reconciliation for the bank account affected
You can only delete reconciliations if you have the Locked one selected - then right click on the ones to delete.- You can only delete the latest Closed reconciliation (and then once that has been deleted the next most recent etc).
- Note that you may need to clear the date range on the filter to see all bank reconciliations.
- Delete reconciliations as far back as you need to including the first reconciliation
Note - if you need to delete the first reconciliation check to make sure that the GL account does not have any transactions prior to the from date of the first reconciliation.
Uploading the bank statement - to find the matches quickly
Why upload the bank statement? If all your transactions are already in the system you do not need to upload the bank statement.
- To use an upload of your bank statement to quickly create missing transactions
- You may pay people and not have entered a payment yet - that is ok - we make it easy to create the payments from the bank reconciliation screen
- Upload your bank statement - this will provide a list of all transactions you have in your bank
...
Trade Finance Bank Account
Discussion
Trade financing is when the bank will forward some funds to you for a % of invoices you have sent out to customers so you can have the cash earlier and not have to wait to collect it.
The account is normally effectively a loan.
The bank normally expects that all the debtors they are trade financing will be instructed to pay into the trade finance account. This helps minimise the loan and also keep track of the performance of individual debtors.
Bank Account Setup as Trade Finance Account
Note - only one bank account can be the Trade Finance account at a time
...
Bank Account on Invoices
When a bank account is flagged as "Trade Finance" then invoices sent from the system or viewed online will have the following bank details:
Debtors flagged as "Exclude from Trade Financing" - will show the bank account with Default set to "Debtor" or "Both"
All other debtors will show the Bank account with the special type "Trade Finance"
Turn on the flag for debtors
...
Set on a debtor
...
Regular Providing invoices to the Bank
The bank will request all invoices to be sent to them regularly - use the Trade Finance Screen for this - then export to xls to send to the bank
...
Aging summary by Due Date for NON trade finance debtors
The aging summary can exclude Trade Finance Debtors
...
OLD Bank Reconcilation - Enter an opening balance for the bank account
| Note |
|---|
New Statement Centred Bank Reconcilation process does not require an opening balance for the bank account. See Bank Reconciliation - Statement centric - uploaded and remembered bank statement lines |
An opening balance is simply a journal - one side is the current bank (or credit account) balance - the other side is normally formation assets or an account chosen by your accountant
Any journal to a bank account once reconciled cannot be changed. It is recommended therefore that opening balance journals NOT include a line for the bank account - but this is done as a separate journal so the opening balance journal can later be changed if required.
...
Fuel Cards
Fuel cards are a Merchant Account - ie not a bank account - but a company you need to pay.
Create the Merchant Account on the Host company
...
Link the Fuel Card to the Asset
...
When the Fuel Statement Arrives
...
Note if you have Branches and Departments defined they will default from the Asset.
And the Asset will be linked to the $ and L from the line on the creditor Invoice
...
Credit Card Payments using Credit Card Terminals
When a bank provides Credit Card Terminals for processing transactions (card not present)
Setup the bank Account Details
...
Select Payment Method EFTPOS (terminal) - then machine. Bank will default from terminal
...
| Note |
|---|
This is the only way a payment can be added to the batch for that terminal Reversal of Payment Journals will be added to the batch (Status - Create a Reversal) |
Payment Batch from EFTPOS Terminal Transactions (per terminal)
When a payment is created
if no batch exists for the Terminal / date / cutoff time combination - a new one is created
if a batch exists then the payment will be added to it
...
| Note |
|---|
Batches will be closed every day by the system |
The batch is cleared in the bank account using the normal method - see Bank Accounts - Creating and Managing#ReconcilingCreditCardBatchesBatches
Credit Card Payments using credit card gateways like Eway
Register
When you register with a credit card gateway - they will ask you for your bank details - and the bank will provide you with a merchant number that gets passed with the transaction information to identify the bank accounts to be impacted by the credit card transaction.
When our system takes a credit card payment - the system passes your merchant number along with the transaction to the gateway and gets a response.
Every response is logged and you will see the result on the transaction you are actioning (sales order, booking etc).
Indicate supported credit cards to limits the options users have on payment
Indicate the credit cards you support
...
The eway Merchant Number to pass through
Using eWay as an example: When you register with eWay - they ask for the bank details they are to put money into. Then they provide you with a Merchant ID number. Place this number in the Merchant ID field for that bank account. When the system takes a credit card transaction it looks for the bank account to use and the merchant ID to pass to eWay.
| Note |
|---|
Note you need the Secure Feature of "CreditCardProcessing" to be a non- zero value on one of your roles in order to see this field. Do not allow many people to see this field |
...
Payments are batched by eway
Multiple payments per day are deposited in your bank - not every transaction
eWay will not send you a transaction for every individual transaction - they will instead send a lump of money 2x per day based on your overall transactions.
So we need to group together all the transactions eWay has told us have been successful into a single $ value that we expect to see go into your bank.
For this reason we batch together all credit card transactions into a "Batch" using the cut-off times told to us by eWay.
...
Using Tyro Credit Card (Card Present) Terminals in POS
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Tyro Terminal NotesYour Tyro Account setup is outside the scope of this help OverviewTyro is a cc capture machine linked to the computer being used (paired). It will have a MID (merchant ID) that links to your company and a TID (Terminal ID that indicates the unique terminal). When first used the MID is checked against the bank account MID and if the TID is not recorded as used before the bank account details are updated with the additional TID. The POS sends requests to the terminal (which responds with approvals / rejections etc) and the responses cause the POS to continue. Where a response is not received quickly the POS will indicate a time out. When the POS is opened by a machine with a paired Tyro terminal - reconciliation files for any of the last 60 days that have not been collected are attached to the appropriate batches and any discrepancies are emailed. Every day any discrepancies are emailed for the previous day. Surcharging
Tyro connects to the machineTyro has software that is installed on your computer that their machine talks to
Troubleshooting Tyro issuesIssues taking payments may be for a number of reasons - the key information we need is the Tyro Logs on the machine. These tell us every request our system made of the Tyro terminal and every response they provided. We need these captured on the day of the problems. An examples issue is - timeout from the Tyro Server (we allow 15 seconds)
|
Setup the bank account
The bank account needs to be
The default bank account for Both (Debtor and Creditor)
Have the Merchant ID (MID) set for Tyro
When a terminal is first used in a store
System checks that the MID is correct and does not allow incorrect MID to transact - warns user
System checks if the TID is already recorded against the bank account - if not it is added with the user login details that first used it
Note: If MID is NOT configured then the terminal match is not checked
Terminal can still capture transactions
ie if a store has a MID setup as 12345. Then a manager walks in with a Tyro terminal setup with MID of 12222 and logs in to the store
they CANNOT take a transaction using their Tyro terminal
...
SaaSplications Setup for Tyro Terminals
Setup and pair with the terminal
Pairing: System > System Settings (Advanced TAB) > Card Present EFTPOS provider (Tyro) (Tyro settings button appears) > Tyro Settings
IF this machine previously had a different terminal paired - then use the button: clear browser cache.
Enter the MID And TID in the machine (this will be validated)
Set Production / Test mode or simulator mode (affects the tyro account impacted)
Pair Terminal button
Request Terminal Info
Integrated Receipts - Ticked if SaaSplications is printing the receipts (SaaSplications POS prints receipts so choose this when using POS)
Print Merchant Copy receipts - used when a tyro machine is not connected to a POS - if using POS then = Unticked
Integrated Surcharge - if your Tyro account has been setup to take a surcharge or not
...
Comparing system journals with Tyro Transaction history
Tyro provides settlement files - all transactions taken by a terminal for a date.
Tyro settles end of day every day in a single account for every MID across all TID’s so this is the expected amount into your bank (less fees if you are not using surcharging)
Tyro closes the settlement at midnight every night
Settlement files are therefore not available until the next day
SaaSplications provides a way to
capture the settlement files
compare them with the system created journals
Why ? so you can find examples where a user may have used the tyro machine and not put the sale through the POS
SaaSplications Journal Batch for Tyro is daily
SaaSplications groups Tyro journals into a batch for the day (per MID)
Used for bank reconciliation
A new batch is created at the first transaction after midnight
Tyro settlement files
Used to compare what SaaSplications recorded VS what Tyro recorded
Each file must be requested by TID from Tyro
The file is not available until after midnight - hence not available until the next day
The file can only be requested by the terminal used
When a Terminal is used every day
The file is requested “silently” by the system for you each day….
When you open the POS AND have a paired Tyro Machine on your computer
SaaSplications checks the if the MID paired to your machine is the MID setup on the default bank account of the host company you are accessing
If it is - then SaaSplications will silently collect a reconciliation file for the previous day (if one exists) and attach it to the banking batch for that date
When a terminal has not been used for some time
When you have not used a TID for some time and need to collect missing files
When you open the POS AND have a paired Tyro Machine on your computer
SaaSplications checks the if the MID paired to your machine is the MID setup on the default bank account of the host company you are accessing
if it is - the POS cash count > Settlement TAB > lists dates this MID and TID did not collect settlement files
Moving Terminals from Store to Store
If a terminal (Tyro TID) changes stores (the MID changes) - then the reconciliation file
Tyro in use in the POS
During a POS transactions
The POS calculates the amount to be captured on the card
The POS talks to the Tyro software on the computer - that then talks to the Tyro Machine
The Tyro machine responds with the result (which may have added a surcharge)
Tyro have a couple of identifiers
MID - this is the merchant account that the terminal will be transacting on - this corresponds to a bank account in SaaSplications (the MID is held in the Merchant ID field and identified as a Tyro merchant ID)
TID - this is the terminal ID
The POS looks for the Tyro Software installed on the local machine
...
OLD Bank Reconciliation Format
| Expand | ||
|---|---|---|
| ||
The POS then passes the amount to be paid to the Tyro software which passes it to the Tyro Cloud which puts it onto the device (so internet connection is required) The user swipes the EFTPOS or credit card - Tyro then tells the tyro cloud to update our POS with the transaction reference, amount etc and the system then completes the transaction Tyro pays all the money for a day in a single payment (except AMEX which is paid directly by AMEX). To see these amounts - use the separate AMEX flag on the bank req.  If the totals are not the same as deposited or reported by Tyro - right click to open the batch an investigate all transactions involved Clearing CC Batches in OLD Bank Statement
Although the payments are grouped together - we have found that the credit card gateways frequently send a different $ amount to what we would expect based on the payments sent to them.
 If the amount they deposited is not the same - you will have to go through the statement they provided and tick off individual transactions on the bank statement so you know which transactions have cleared. |
| Note |
|---|
See Bank Reconciliation - Statement centric - uploaded and remembered bank statement lines for reconciliation instructions |
Payments from/to Debtors and Payments to/from Creditors and bank accounts
When you have entered an invoice you want a payment to reference
When doing a Creditor Payment, Creditor Refund, Debtor Payment or Debtor Refund - you can select the bank account when you do the transaction - and that will place the transaction in the reconciliation screen for that bank account
...
When you do not want to enter an invoice - you just want to record a payment
| Note |
|---|
Normally you will want to enter all invoices into the system for record keeping reasons. DO NOT use this transaction and also enter an invoice - it will be double counting |
Use "Supplier Payment (No Invoice)" or "Customer Payment (No Invoice)" to create the transaction - referencing the bank account
...
Cash Batches
| Note |
|---|
If your business is collecting cash while delivering products on Waybills - review Waybills - Grouping deliveries together and doing consolidated picking across orders#Createthepaymentsandaddthemtothedriversbatchforthatday |
Cash Batches are used when Cash is Collected by Sales Reps, Delivery Drivers and Bus Drivers
They count the cash in the batch as they drop it off.
Do a second count of each cash batch to confirm the amounts.
Group together multiple amounts of cash into a single bank deposit.
Capture the cash transaction
Sales Reps, Delivery Drivers and Bus Drivers are collecting cash during a day of driving around visiting customers.
The cash they collect is grouped into a batch to be counted at the end of the day. This is known as a "Cash Batch"
They may also spend some of this cash as they go - to wash the car, parking or other items. This is known as a "Spend Money" - cash was used.
If they purchase items using a credit card (for example a fuel card) this is not included in the daily batch and is not a spend money as no cash was spent.
Cash payments may be recorded in a number of ways by drivers
If your business manages orders
As a cash payment of a sales order or booking - from the sales order screen
As a cash payment not linked to a sales order - simply a cash collection from a debtor they visited from the debtor or in the driver portal.
If your business manages bookings
The bus drivers portal as they drive
As a cash payment for a booking in the driver portal or entered later once they have returned.
The cash payment will default to their batch for the day
Cash Counting by drivers
Count the Cash taken during a number of days - Drop at office
At the end of the day the cash needs to be counted by the driver and will include
Cash total to count = Cash collected - cash spent (Spend Money Transactions Only).
...
The driver will do a first count of the cash and the cash batch will move to "Counted" status - note that the counted cash may not match the expected cash.
Then batch can then be counted by a second person and multiple batches banked in a single banking deposit.
Count the Cash taken over a number of days - Driver Deposit to the bank
If the driver is depositing the cash to the bank - the batch will be closed and a journal created to the bank for the amount deposited
...
Once the cash is dropped off to the office - second cash count
The office will do a second count of the cash - noting any discrepancies as an adjustment journal
...
Office does a second count and moves the batch to locked status
...
Group multiple cash counts into a single amount to deposit to the bank
Depositing cash into the bank - adding multiple amounts of cash into a total to take to the bank
After second counting a number of batches - the batches can be grouped together into a bank deposit
...
The batch will then have a reference on it to the journal that links it to the bank statement
...
| Note |
|---|
The Banking Batches Screen Consolidates this view into a single screen |
| Include Page | ||||
|---|---|---|---|---|
|
How does the cash deposited appear in the OLD bank statement
Cash batches appear as a single journal line in the bank statement ( A yellow General Journal) as all the cash was deposited as a single cash amount
...
Reconciling the OLD bank statement
Getting ready to reconcile transactions
Reconciling the bank statement is a process of confirming each of the transactions you expect to have appeared are there and creating other transactions that you did not record in your business system. When you tick the box in the S column you are confirming that you have seen that transaction in the bank statement.
Choose the bank account
...
The Reconciliation screen will then open with the last reconciled date
Put in the date of the statement that you have in front of you - this is the date you are reconciling to
...
Enter the Statement Balance. The variance will populate showing how much $ transactions you have to find and tick as reconciled
...
Note that the transactions listed will be any transactions prior to the Reconciliation date that have not yet been reconciled.
OLD Bank Reconcilation - Reconciling individual transactions
Next you need to look through your bank statement to find transactions to clear. Normally you have a printed out statement and you tick off each transaction as you find it.
It can help to untick the "presented" list - this makes it easier to find the transactions you have not yet cleared. As you clear transactions you can refresh and they will hide.
...
The bank reconciliation shows some transactions that are part of a credit card batch (see credit card section above in this document) - If the amount we say should be there is the same as in the bank statement you can clear these using a rightclick.
OLD Bank Reconcilation -Reconciling Credit Card Batches Batches
The bottom RHS of the screen has a list of batches. A batch is a group of transactions. As you can see all the individual transactions are still visible in the bank statement - this is because it is common that what we expect and what is paid to you will often be different - because of fees, bounced transactions and other reasons. You can quickly clear all in batch using a right click if the values match. Otherwise you will need to use the credit card statement to clear them independently.
...
Enter Bank Fees
This is a good time to enter any bank fees that you find when looking at your credit card gateway trading statement
...
Remember that this is a grid like anywhere else in the system - so you can filter the transactions (CNTRL F) or top LHS of grid for filter - it will filter using any information in the grid
OLD Bank Reconcilation - Filtering the transaction list
using letters
...
Filtering using numbers
...
OLD Bank Reconcilation -Review of past reconciliations including the PDF report
At any time you can print a preview of the reconciliation report using the print button.
When you have completed the reconciliation (Reconcile Now) button all the transactions in the system that have been marked as reconciled will be locked and cannot be changed.
To view the report for any reconciliation - the current screen will then show all the transactions for that reconciliation (locked).
...
To view the report use the print screen - or the link to the saved report.
This is what the report looks like
...
| Note |
|---|
The saved report shows exactly the situation at the time of doing the bank Req - there are two numbers that may now be different... When viewing a closed bank Req - the unpresented values are live values (not saved ones). Hence they will show you if any transactions prior to the reconcilation date have STILL not been cleared. The saved report shows accurately at the time of doing the bank req:
The Bank Balance is often not the same as the Balance sheet balance - due to un-presented transactions.
The numbers on the saved reports are expected to vary with the balance sheet balance at the date - this is best illustrated with an example:
|
OLD Bank Reconcilation - Deleting Bank Reconcilations
Go to Bank Reconciliation for the bank account affected
- You can only delete reconciliations if you have the Locked one selected - then right click on the ones to delete.
- You can only delete the latest Closed reconciliation (and then once that has been deleted the next most recent etc).
- Note that you may need to clear the date range on the filter to see all bank reconciliations.
Delete reconciliations as far back as you need to including the first reconciliation
...
Note - if you need to delete the first reconciliation check to make sure that the GL account does not have any transactions prior to the from date of the first reconciliation.
OLD Bank Reconcilation - Uploading the bank statement - and find the matches quickly
Why upload the bank statement? If all your transactions are already in the system you do not need to upload the bank statement.
To use an upload of your bank statement to quickly create missing transactions
You may pay people and not have entered a payment yet - that is ok - we make it easy to create the payments from the bank reconciliation screen
Upload your bank statement - this will provide a list of all transactions you have in your bank
| Note |
|---|
Upload File FormatThe Bank statement upload needs to have the following headings - modify your CSV file to suit
Negative values will NOT be converted - you need to create separate columns of debit and credit |
...
Then search for each transaction to find a match - or create the transaction in the system by right clicking on it.
...
You can start a bank fee journal from here as well - this will create a journal on the creditor you configured for the bank with the other side defaulting to using the account referenced in Symbols Config - BankFeesGLAccount
FX bank account transfer of funds
Use the wizard to transfer funds - see Foreign Currency Transactions (fx)
Shutting Down Bank Accounts
When you are closing a bank account there are a couple of things to do in the system
...
In the GL - flag the GL account as "Disallow new entries" so it cannot be used as a bank account any more.
...
Related articles
| Filter by label (Content by label) | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Related issues
...