Page Comparison

...

Extracting Bank Reconcilation from Readysell

1. Log onto Readysell>Financials>Cashbook>Bank Readysell>Financials>Bank Reconciliation
2. Check that there are no outstanding bankrecs bank reconciliations for this bank account by dropping the filter in the top ribbon and selecting ‘Outstanding Bank reconciliations’
3. Click on New New to start a new bank rec
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 exported bankstatement bank statement from the internet 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 appearappears if need be
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 reconciliation lines filter view (if you have one set up) in both the Readysell and Statement lines detail area

Importing the Bank Statement Lines

1. Still in the Bank ReconcilationReconciliation, 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 Highlight the QIF file that you just exported from the bank 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 bank payments and bank deposits have been created 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 Imported Bank Statement

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, check and finalise each one of them ensuring they line up to the bank reconciliation statement line that was imported .

Bank Payments Module - for auto created payments 

1. Financials>Cashbook>Bank Financials>Bank Payments
2. Click on the filter in the top ribbon and select 'outstanding bank payment'.
3. Check each of the auto created bank payments against the bank reconcilation reconciliation imported bank statement linesline.
4. Make any changes to the bank payments to line up to the bank statement .line
   Whether by adding another gl general ledger 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  ticked (true) and the check box of 'marked' on the readysell lines is ticked (true)
7. Look Now look for any 'Outstanding Bank Payments' that were created by a recurring Bank Payment.
8. Check these against the imported bank statement lines.
9. Make any changes to the bank payments 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 Financials>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 reconciliation imported bank statement lines.
4. Make any changes to the bank deposit to line up to the bank statement.
   Whether by adding another gl general ledger 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 deposits 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 deposits, in the bank reconciliation, the check box 'auto match' on the bank statement lines is ticked (true) and the check box of 'marked' on the readysell lines is ticked (true)
7. Go back to the bank reconciliation and check all results

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

1. Go back to the bank reconciliation.

2. In both detail areas ensure you are on the drop down filter of ‘unmatched lines’ and 'unmarked lines'

   Expand
   title Show me

   
   

3. Then start manually matching by working from the bank statement lines to readysell lines.
   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 tab and then click on 'Marked' check box in the readysell lines.
4. Click on RefresRefresh every so often
   Both lines with disappear from the screen.

Review what has not been auto matched and see why it has not been automatchedauto matched.
You may need to create a Bank Reconcilation Reconciliation 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 Reconciliation>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 all entires entries of the Imported Bank Statement Lines have been reconciled and the Bank Statement balances with No Variance values you can Finalise the Bank Reconcilation Reconciliation by clicking on the Finalise action button.