Page Comparison

...

Procedure

...

Exporting the Bank Statement from your Bank Account Online

1. Log onto your physical bank account
2. Select the bank account in question
3. Select the start and end date of the statement you are about to export and click on display or search
4. Ensure that this date range is the right range
5. Select Export button of the screen
6. Select the correct export type depending upon which bank you are with and what is compatible with Readysell. See doco Setting up and using automatic bank reconciliations
7. Export the file to a folder on your desktop (downloads>bank statement)
8. Ensure to delete any old exported files once those bank reconciliations are completed.
9. The bank statement for the date you are about to reconcile is ready to import

Extracting Bank Reconcilation from Readysell

1. Log onto Readysell>Financials>Cashbook>Bank Reconciliation
2. Check that there are no outstanding bankrecs for this bank account by dropping the filter in the top ribbon and selecting ‘Outstanding Bank reconciliations’
3. Click on New to commence a new bank reconciliationNew 
4. Click on Extract Bankings from the top task bar
   A pop up window will display
5. Select the same bank account (that is, the one in Readysell that matches the export exported bankstatement from the Bank)
6. Enter the closing date (ensure that the start and end dates in Readysell line up to the exported bank statement) and click on OK
7. Click on the ‘Refresh’ action button until the Readysell lines appear
8. Enter the Statement Closing bank figure and click on TAB
9. Check that in the detail area, the filter is on “All Lines” in both the Readysell lines and the Statement lines
10. Check that you are on your bank reconcilation lines filter (if you have one set up) in both the Readysell and Statement lines detail area

...

1. Still in the Bank Reconcilation, click on ‘Import Transactions’ action button from the top task bar
2. Ensure that you are in the right folder that you downloaded the statement into
3. Select the QIF file that you just exported and click on Open
4. Wait for the system to pop up with the Readysell conclusion of how many transactions, how many matches, how many new payments and deposits and how many left to reconcile.
5. Check the message for the number of Payments and Deposits that were auto created
6. Click on OK

Finalising the auto created Bank Payments and/or Bank Deposit from the Import

If the

...

Importing of the bank statement created any bank payments and/or bank deposits, go to the Bank Payments module and then the Bank Deposits module.

...

Bank Payments Module - for auto created payments 

1. Financials>Cashbook>Bank Payments
2. Click on the filter in the top ribbon on each module and change it to outstanding once in each module.Check them, make any changes to the bank payments and or bank deposits that were auto created. and select 'outstanding bank payment'.
3. Check each bank payment against the bank reconcilation imported bank statement lines.
4. Make any changes to the bank payments to line up to the bank statement.
   Whether by adding another line to the transaction or making a change to it to line up to the bank statement and click on Finalise.
5. Ensure that the bank payments are finalised before you go back to continue with your open bank reconciliation
6. Once you click on Finalise on each of the auto created bank payments, in the bank reconciliation, the check box 'auto match' on the bank statement lines is true and the check box of 'marked' on the readysell lines is true
7. Look for any 'Outstanding Bank Payments' that were created to recur.
8. Check these against the imported bank statement lines.
9. Make any changes to the payment to ensure it lines up to the value of the imported bank statement payment and click on finalise.
10. Go back to the bank reconciliation and check all results

Bank Deposits Module - for auto created deposits

1. Financials>Cashbook>Bank Deposits
2. Click on the filter in the top ribbon and select 'outstanding bank deposits'.
3. Check each bank deposit against the bank reconcilation imported bank statement lines.
4. Make any changes to the bank deposit to line up to the bank statement.
   Whether by adding another line to the transaction or making a change to it to line up to the bank statement and click on Finalise. (ensure
5. Ensure that both the bank payments and bank deposits are finalised before you go back to continue with your open bank reconciliation)
6. Once you click on Finalise each of the auto created bank payment and then bank deposits, it should auto match on the bank reconciliationdeposits, in the bank reconciliation, the check box 'auto match' on the bank statement lines is true and the check box of 'marked' on the readysell lines is true
7. Go back to the bank reconciliation and check all results

Now to continue with the Bank Reconcilation for transactions on the Bank Statement Lines that have not been reconciled.

1. Go back to the bank reconciliation.

2. In

   the detail area change

   both detail areas ensure you are on the drop down filter

   to ‘unmatched’ and/or unmarked in both detail areas

   of ‘unmatched lines’ and 'unmarked lines'

   Expand
   title Show me
   Image Added Image Added

   
   

3. Then start manually matching by working from the statement lines to readysell lines by clicking in the Matched check box on .
   Look at the first unmatched bank statement line and try and find it in the Readysell lines.
   Once you find it then click on the 'Matched'check box within the statement lines and marked tab and then click on 'Marked' check box in the readysell lines.
   Both lines .

...

1. with disappear from the screen.

Review what has not been auto matched and see why it has not been automatched.
You may need to create a Bank Reconcilation rule to meet the criteria

If you have a transfer of money from one bank account to another, then insert a Bank Transfer from within the Bank Reconcilation>New Banking>Bank Transfer. See link Entering a Bank Transfer

If there is a slight variance in the Deposit of Cash/Cheques or Eftpos use the Correct Value option from within the bank reconciliation.
Before you use this please investigate to see why there might be a variance between what was banked and what is in Readysell. Performing a bank reconciliation manually (not importing the bank statement)

Once the Bank reconcilation Balances click on Finaliseall entires of the Imported Bank Statement Lines have been reconciled and the Bank Statement balances with No Variance values you can Finalise the Bank Reconcilation by clicking on the Finalise action button.