| Table of Contents |
|---|
| Anchor | ||||
|---|---|---|---|---|
|
This document will take you through the general procedures of the bank; going over how it is programmed to be used. We will cover a general data overflow of Cash Drawer Banks flowing into Brick-n-Mortar Banks to help make reconciliation of cash drawers and bank statement easier. We will finish up
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
...
We setup up each location with their own Daily Cash Receipt Bank C1, C2, C3, for an example.
Each location code can have a default bank code tied to their location via: ACR > Setup > System Integration
Each bank code will have a deposit transaction to match to each AR Receipt or Grain Sales Settlement.
As you key in the daily receipts, you can take advantage of the deposit number that is meant to group your deposits to a deposit slip. You can set this to default today's date in YYMMDD format automatically under Bnk > Setup > General Information.
At the end of the day, you prepare the nightly deposit. Even if you don't take a deposit, physically, to the bank every day, still do a deposit for each day. It keeps things consistent and makes balancing easier.
...
Run the Bank Deposit Register to help aid in creating your deposit. BNK > Report Manager > Standard > Bank Deposit Register. This report, subtotaled by the Deposit Number, should equal my nightly deposit. I could use this to list my checks for the deposit slip.
Then you transfer ONE lump sum amount (nightly deposit) out of the Daily Cash receipt bank and move it into your Brick-n-Mortar bank in a single amount. Use the same date as the daily deposits. Payments on the 11th match transfer to brick-n-mortar bank on 11th.
This single deposit amount into that bank code will match the bank statements single deposit amount of $453,422.15, thus making reconciliation at month end much easier.
Now as a double check, your standard ACR A/R PAYMENT RECEIVED REPORT should also match the bank deposit amount.
If you do not have enough funds to deposit to the bank. For example, there was supposed to be $5 more and that dollar amount it missing then you key a manual transaction to cash long/short. This amount makes up the difference between the physical deposit and what is actually keyed into AGRIS, when the reports don't match up.
The last step is to reconcile the cash drawer back to you beginning amount. BNK > Bank Maintenance > Select Bank Code > Reconcile Transactions > Select each line to place an X by the line. When you finish the bank balance will be back to zero or whatever cash balance you are carrying.
...
Reconcile Transactions using the bank statement. Bank Maintenance > Bank Code > Reconcile Transactions > Place an X by each transaction that is on the bank statement, marking it cleared. Always use a recon date that matches the ending date of the statement.
If you reconcile a transaction you did not mean to, then you can edit that transaction under BNK > Bank Maintenance > Select Bank > View/Edit transactions to make it ACTIVE again.
Run the bank standard report, CANCELLED TRANSACTION REGISTER, to verify the deposit and withdrawal totals in AGRIS match the totals on the bank statement. Use the DATE RECONCILED to limit transactions.
Compare these withdrawal and deposit totals to the statement. These should match and prove out that everything the bank knows about for the month is keyed into AGRIS and reconciled. Example statement to show totals:
Run the Bank Reconciliation report –which uses the above calculation. This report will print all ACTIVE documents and give an ending balance to match the bank statement. The ending Reconcile balance should match your bank statement balance.
Keep this statement for auditors as you cannot recreate this report. It is a onetime report at point of balancing.
...
BNK > Report Manager > Bank Account Reports > Report Writer > Insert
Copy from the 1) Standard Report > Bank Register
Press OK to pass the Report type Screen. No changes here.
Edit the report title.
Select Line 01 on the "Define Calculation Fields" screen. Your Line 01 will be blank for title and Calculation.
Enter the 1st field at option 3) Trx AmountCalculation of times (x)2nd Field number of 99) Flat amount.
2nd Field Number = 1.0Calculation Title = FIXED AMOUNTExtension Ability = 5) Use Absolute Value (note that this is key to this report)It makes the value positive no matter what. Decimal Positions = T for total Total Ability = 2 )Accumulate Totals
Select the following Sort fields.
No changes to the Range Selection Criteria.
No changes to Screen #1 of 2 for the Value Selectin Criteria:
Screen #2 of 2 of the Value Selection is important. This is where you key in the 1=Equal To option. And the dollar amount you are searching for.
No change to the Subtotal & Other Options Screen.
Answer No to all the questions on the Additional Options Screen. By not calculating the bank balance and the recon balance, the report prints faster.
Do not change any of the field printing positions. Save/Exit.
You know have a user-defined report where you can key in any dollar amount you are looking for and have it print on the report. Just go to the Value Selection Criteria, screen #2 of 2 and key in the dollar amount.
The report searches all banks you are looking for and dates (if date range opened up) to find any deposit or withdrawal that matches that amount. It makes it much easier to find things that have been keyed and voided several times.
| Anchor | ||||
|---|---|---|---|---|
|
Register to Ledger to Bank Recon...
Data entry completed for SJI Period.
Set your earliest date allowed to the next month.
Everyone out of the ACR-ACP-BNK-GRN-PAY packages. Bank is unique in that the Bank Ledger Accounts will be updated by 5-different packages.
Select your SJI period. SJI > Select SJI Period > Select period to be default. All data keyed or edited between these date ranges will be pulled into the SJI and summarized into ledger entries by location code, transaction Code, and then source code.
!worddavbf37602f48876f8dcb0d65f12a11389c.png|height=247,width=267! Each package pulls it's transactions into ledger and posts to the Bank ledger accounts. Each package interfaces to the BANK code assignment in Bank by keying in an account code of BANK.
Run the Create SJI process to create the SJI entries. SJI > Create System Entries > Select Payroll Sent reports to the spool. SJI > Create System Entries > Select Bank. Send reports to the spool. SJI > Create System Entries > Select Accounts Payable. Send reports to the spool. SJI > Create System Entries > Select Accounts Receivable. Send reports to the spool. SJI > Create System Entries > Select Commodity Accounting. Send reports to the spool. DO NOT DELETE until Fiscal Year is closed.
Select the Ledger Period. LDG > Select Ledger Period > Select Default Period.
Post the System Journal entries. LDG > Journal Entries > System Journal Entries. Answer YES to All Packages. (Note: AGRIS only allows you to transfer the entries once. So even if you answer yes to a package that has already posted, don't worry. It can only be pulled once. You will not double the ledger balances by just leaving all questions at yes.)
Run the Ledger trial Balance report. LDG > Reports Manager > Journal Entry Reports > Standard reports > Trial Balance Report. This is the report that you use to balance to the subsidiary Bank Accounts.
Run the Bank Register with Running Balance for SJI Period Ending Date. Everyone MUST be out of the BNK package when this report is run. Run after a "verify account balance" function has been run. BNK > Bank Account > Bank Maintenance > Select Bank > 6) Bank Balance Inquiry > Answer YES to "Re-Calculate Bank Balance" then run report BNK > Reports Manager > Bank Account Reports > 1) Print Standard Reports > Bank Register Trx Date Beginning and ending should be last day of the SJI period > Print
This report takes the Purge Balance and adds up all the transactions up to the first transaction you are printing for the filters. Then adds the rest of the transaction up to the end of the filter range.
The ending balance of the Bank Register should match the Trial Balance Report.
...