Bank Reconciliation Grid
Starting date choice. Ending date choice
Starting Bank Balance....$ Starting GL Balance on date $........ (Difference $121 )
| From Bank | From System | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Date | Description | Deposit$ (5) $129 | Withdrawal$ (7) $ 2,456 | MATCH | TransID | Date | Description | Deposit $ | Withdrawl $ |
| On match move date of transaction if different | |||||||||
Ending Bank Balance....$ Ending GL Balance on Date $ (Difference)
Process Flow
Step 1 = create starting balance for bank account
Journals exist in SaaSplications > create a single match for all past journals to get to the starting balance.
Step 2 = upload bank file
Check first line in the upload final balance amount aligns with previous upload (if one exists). If no previous uploads exist - check if any following transactions exist and do same check for last line in the upload statement.
Step 3 - attempt to match on batch transactions (Tyro non amex $ on date or 2 days prior). If date and tyro align but value is wrong - indicate as possible match
Step 4 - attempt match on tyro batch amex on date or dates prior
Step 5 - attempt match on date and amount
Step 6 - Attempt to match on debtor "Bank Transaction Identifier", search code, invoice number/s,
Step 6 - Show proposed matches in grid (Multiple ?) > person can accept or not accept. If accepted move to matched. if not accepted check for any other possible matches ?
Step 7 - user can create new transaction (right click > Create) > list as matched
Step 8 - user can attempt a search using pieces of the transaction description (exists)
Balance Sheet
Indicate on Balance Sheet if GL Balance is not the same as statement balance on date (Red cell)