Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

Overview


Excerpt

...

bank reconciliation is a process that explains the difference between the bank balance shown in an

...

organisation's bank statement

...

(as supplied by the bank

...

) and the corresponding amount shown in the

...

organisation's own accounting records at a particular point in time. If your account records does not agree with the bank statement, you must determine where the discrepancy is and make the appropriate corrections.

...

It is normal for a company's bank balance to differ from the balance as per bank statement due to timing differences. Such timing differences appear as reconciling items in the

...

bank reconciliation.

...

Bank reconciliations should be done by date

...

consecutively and periodically. Please ensure that the last bank reconciliation for a financial year is the last day of June - the system will not allow you to extract into the next month. You cannot commence a new bank reconciliation until your current bank reconciliation is balanced and finalised for the

...

bank account you are reconciling

...

.

Warning

If you do not have any transactions on the last day of the year, create a bankrec for the 30th of June for each bank account and insert a $0.00 deposit from within the bankrec itself by clicking on New, New Bank Deposit. Present it and finalise the bankrec for the last day of the financial year. Then start another bankrec for the beginning of the next month that stands for the first period of the next financial year


Image Added

Image Added

The first bank reconciliation must represent the closing bank reconciliation from your old system and must balance back to your general ledger bank accountFor the first

...

bank reconciliation, the site will need to provide

...

Readysell with the statement opening date and statement opening balance figure. Readysell will insert this for you as the starting

...

bank reconciliation

Bank 

...

reconciliations are set to compress depending upon what rules have been set up against each tender

...

(usually set up by Readysell at commencement of business). As well as making it easier to navigate the bank reconciliation, these compressed figures are used to guide the automatic matching and automatic generation features based on the tender and bank reconciliation rules.

All transactions on a bank statement that relate to a card should be entered onto the card not through the bank reconcilation as a manual entry.
In respect to Visa/Mastercard/Amex Card statements, if the transaction on a bank statement has a card, enter a supplier debit against the card and expense it correctly then enter a supplier payment using the right tender to point to the right visa card ensuring both transactions are dated the date on the visa card statement. Other all other non stock miscellanous transactions that you dont have a card set up for, then you can enter via the Bank Reconcilations as either a deposit or payment ensuring to date these the date on the bank statement and expense correctly.


Note

There is a system reference under the name of cashbook code = BANK-RECONCILIATION-AUTO-MATCH-DAYS with a value.

This has a default of 9 days.

The field 'Matched Reference' on a bank reconcilation line is filled in at the time you import the bank statement line using the comments in the 'text' field from the bank statement line once a auto match is found based upon, date, value etc.


Getting Started

Child pages (Children Display)
pageGetting started with bank reconciliations

...

Buttons

Refer to Common Buttons.

ImageFieldDescription
Image Modified
Extract BankingsExtract
bankings
readysell banking transactions into this bank reconciliation
Image Modified
Import TransactionsImport bank transactions from the Exported Bank Statement into Readysell for automatic matching and automatic transaction generation
Image Modified
Generate CorrectionsGenerate
correction bank payments
corrections for a banking that will create either a bank payment / bank
deposits
deposit based on the
values
value in the correction column. This action button should only be used for minimal variances usually where cash varies between what is banked and what is recorded in Readysell. If a transaction value for a source transaction has been entered incorrectly, ensure that you fix the source transaction on the card.
Image Modified
New BankingCreate
a
new banking in this reconciliation being either a bank deposit/bank payment or bank transfer

Fields

FieldDescription
Date
 
Date created for the Bank Reconciliation
Number
 
Bank Reconciliation transaction number
Status
 
Status of the Bankrec
Account Site
 
Bank Account General Ledger Account
Statement Open DateThe statement opening balance date for the Bank Reconciliation, This value is Populated from the closing balance of the last bank statement.
Statement Open
Bal
BalanceThe statement opening balance for the Bank Reconciliation. This value is Populated from the closing balance of the last bank reconciliation for that bank account.
Unpresented Bal
Equals Statement Closing balance from the previous bank reconciliation for that bank account
Unpresented BalanceExpected GL Closing Balance - Computed Closing Balance
, the statement closing balance date for the Bank Reconciliation
. The sum of the items not yet marked
Statement Close Date
 
The Statement Closing Date. This is a manual entry from the Bank Statement. The date you are last reconciling to.
Statement Close
Bal
BalanceThis is the statement closing balance for the Bank Reconciliation and is entered from the Bank Statement. This is not calculated.
Value Marked
Sum
The sum of the transaction value of marked Lines, this field shows the value marked for the Bank Reconciliation
Comp GL Close
Bal
BalanceStatement Opening Balance + Total Value
, the
(all readysell transactions within the bank rec), also known as the 'expected General Ledger closing balance'
Comp Close
Bal
BalanceStatement Opening Balance + Value Marked, this is the computed closing balance
Actual GL Close
Bal
BalanceBank Account GL Balance at Statement Closing Balance Date, this field shows the general ledger closing balance for this Bank Reconciliation
GL VarianceGL Closing Balance - Expected GL Closing Balance
VarianceStatement Closing Balance - Computed Closing Balance, a
lso
also known as the "Statement Variance"

Lines Tab

Buttons

ImageFieldDescription
Image Modified
Mark Selected
 
Mark the transaction highlighted within a bankrec.
Image Modified
Unmark Selected
 
Unmark the transaction highlighted within a bankrec.
Image Modified
Mark All
 
Mark all transactions highlighted within a bankrec.
Image Modified
Unmark All
 
Unmark all transactions highlighted within a bankrec.

Fields

FieldDescription
DateThe date and time of the
bank reconciliation
banking (source record date)
Tender
 
The tender that was used for that source of banking
Site
 
The site of the banking
Workstation
 
The workstation for that source banking
Transaction Number
Unique
The source transaction number
for this line
Card
 
The card that relates to this banking
DescriptionThe description of
this line
the source transaction
Payment ReferenceThis is the payment reference
for this line
entered into the Customer Payment or Supplier Payment at the time of entry
Transaction ValueThis is the transaction value for this line or the Sum of all transactions for the tender
Corrected Date
Corrected date is a date and time
Manual entry of the date
Corrected Value
The corrected value
Manual entry of what the value should be.
MarkedCheck this box to mark the line
Matched ReferenceThis is the matched reference
for this line
value from the Imported Bank Statement
Value Excluding FeeThis line shows the value excluding fee for this line

Buttons

Image Modified
 

Image Modified
Show in report- Shows banking records in a report
Image Modified
Show the original transaction that generated this banking

References

DateThe date and time of the banking record
Card
 
The Cardid of the source transaction
Transaction NumberThis is a unique transaction number for the source banking record
Payment ReferenceThis is the payment reference for the source banking record
DescriptionThis field contains a short description of the source banking record at the time of entry
Presented dateThe date and time that the payment was presented
ValueThis field shows the value of the banking record within a bank reconciliation
Value Excluding FeeThis field shows the value of the banking record, excluding fees