Anchor
_Toc369717013 _Toc369717013

Anchor
_Toc369717588 _Toc369717588

Detail Balancing of AR to Ledger Trial Balance

...

1. Data entry completed for SJI Period.

2. Set your earliest date allowed to the next month.

3. Everyone out of the ACR package.

4. 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, then source codes.

   Image RemovedImage Added

5. Run the Create SJI process to create the SJI entries. SJI > Create System Accounts > Accounts Receivable Sent

   1. Send reports to the spool.DO NOT DELETE until Fiscal Year is closed.

6. Select the Ledger Period. LDG > Select Ledger Period > Select Default Period.

7. Post the System Journal entries . in LDG > Journal Entries > System Journal Entries Answer YES to Account Accounts Receivable (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.)

8. Run the Ledger trial Balance report . in LDG > Reports Manager > Journal Entry Reports > Standard reports > Trial Balance Report.

   1. This is the report that you use to balance to the subsidiary A/R and Prepayment Accounts.

9. Run the AR Balance Report with GL Reconciliation for SJI Period Ending Date

   1. Everyone MUST be out of the ACR package when this report is run. Run after an aging function has been run.

   2. ACR > Reports Manager > AR Balance Reports > Standard > AR Balance Reports > AR Aging Analysis by Location codes > Additional Options Screen > Answer YES to "Calculate Ledger Reconciliation Balances?" > Key in the ending date that matches the ledger period ending date.

   3. This report takes the current balances and backs out the invoices/receipts to get back to the balance on the date requested.

10. The ending balance of the Ledger AR and Prepay accounts should match the AR Balance Report.

...

The SJI process gathers all the invoices (item and manual) and receipts (payments and prepayments) that were keyed into the ACR for the SJI time frame. It looks at each transaction code (assigned in SJI System Accounts) and assigns the dollars and quantities of these documents to a ledger accounts. So if you know what transaction code should be hitting your ledger account, then you know what document to be looking for when balancing.

Anchor
_Toc369717017 _Toc369717017

Item Invoices: Debit Accounts Receivable for the amount of the invoice (AR-transaction code)Credit Inventory Sales for the amount of the Lines Items (SL-Transaction code)Credit the Sale Tax Payable for the amount of tax (S1-S4 Transaction code)Debit the Inventory Cost of Sales for the cost of the product (CS-Transaction code)Credit the Inventory Asset for the cost of the product (IV-Transaction Code)

Anchor
_Toc369717018 _Toc369717018

Manual Invoices: Debit Accounts receivable for the amount of the invoice (AR-Transaction Code)Credit the GL Account (Finance Charge income, for example)(manual distribution)

Anchor
_Toc369717019 _Toc369717019

Payment (cash or ROA) Debit Bank Code Account (PM-transaction code which is normally replaced by bank code)Credit Accounts Receivable (AR-Transaction Code)

Anchor
_Toc369717020 _Toc369717020

Prepayments: Debit Bank Code Account (Bank Code)Credit Prepayments contra-asset account (PP-Transaction Code)

Anchor
_Toc369717021 _Toc369717021

Application of Prepayment to invoice: Debit Prepayments contra-asset account (PP-transaction code)Credit Accounts Receivable Invoice Number (AR-Transaction code)

...

Anchor
_Toc369717025 _Toc369717025

Step One:
Think about how you are balancing a transaction code on a document to the ledger. Example: balancing Accounts Receivable subsidiary, only the AR-Transaction code should be hitting the 1120 ledger account. And if only AR transaction codes should be hitting the AR ledger account, and then only invoices (item or manual) and payment (cash or prepay) should be hitting that ledger account. Because that is the only time the AR-transaction code is used.

Anchor
_Toc369717026 _Toc369717026

Step Two:
Build a current SJI Exec Work file that includes the current month you are trying to balance. It can include more time than the current month.

Anchor
_Toc369717027 _Toc369717027

Step Three:
Run the standard Ledger Account detail report for the AR Ledger Account. Compare the ending Transaction Total with the Trial Balance Change Amount to see if they are the same. Or the change amount from a Ledger Account Inquiry. If they are NOT, then data has been changed AFTER the SJI was created. This could be new data added or reversed, but something has been done to documents with AR transaction codes in the month that you have already gathered the data for the ledger.

Here, the amounts $7,827.00 different. This is stating that if we re-ran the SJI's again for this time period, it would post a larger credit to the ledger. What was invoice or payment entry/edit/reverse was backdated?

Anchor
_Toc369717028 _Toc369717028

Step Four:
If AR is out of balance, then OTHER accounts are out of balance as well. If we can find the other accounts then it will give us a heads up of the type of invoice or payment record that we are looking for.

Run the SJI Execution ID report called MIMIC SYSTEM JOURNAL REPORT using the parameter settings to limit this report to just entries from the AR package. SJI > Report manager > Execution ID reports > Standard Reports > MIMIC SYSTEM JOURNAL REPORT >
Key in date range to match ledger period > go to Additional Options > Answer NO to everything but AR. This will give you only the entries that posted with the ACR SJI Creation Process

Compare this report to the standard SJI Entry report MIMIC EXECUTION ID REPORT. SJI > Report manager > Journal Entry Reports > Standard Reports > MIMIC EXECUTION ID REPORT >Select AR to AR for Source parameter and the current period
This gives you all the entries that did post.

...

This finds the difference for the AR and Finance Charge account. Invoice 999-JZ0034 was reversed and answered YES to re-use document number. So it is no longer in the system.

Anchor
_Toc369717029 _Toc369717029

Step Five:
Make a manual ledger entry to back out the finance charge from the ledger. Debit Finance Charge income $841.00Credit Accounts Receivable asset $841.00

...

Anchor
_Toc369717031 _Toc369717031

Step One:
Think about how you are balancing a transaction code on a document to the ledger. Example: balancing Prepay subsidiary, only the PP-Prepayment Transaction code should be hitting the 2510 ledger account. And if only PP transaction codes should be hitting the PP ledger account, then only applications to invoices and accepting cash for prepayment should be hitting that ledger account. Because that is the only time the PP-transaction code is used.

Anchor
_Toc369717032 _Toc369717032

Step Two:
Build a current SJI Exec Work file, if one is not already built.

Anchor
_Toc369717033 _Toc369717033

Step Three:
Run the standard Ledger Account detail report for the Prepay Ledger Account.

...

If they are NOT, then data has been changed AFTER the SJI was created. This could be new data added or reversed, but something has been done to documents with AR transaction codes in the month that you have already gathered the data for the ledger.

Anchor
_Toc369717034 _Toc369717034

Step Four:
If Prepay is out of balance then OTHER accounts are out of balance as well. Run the MIMIC reports for the Prepay ledger account using the steps from balancing AR.

Anchor
_Toc369717035 _Toc369717035

Step Five:
In this case, we can tell just from the LEDGER ACCOUNT DETAIL REPORT of Step Four that the issue is a reversed prepay. The TRIAL BALANCE REPORT only knows about the 379.00 credit, which knowing document would be a prepay entry.But the SJI Work File LEDGER ACCOUNT DETAIL report shows that document was voided.So we need to reverse the prepay entry in the ledger with a manual entry.
Debit Prepay Holding $379.00Credit Bank Account $379.00

...

Anchor
_Toc369717037 _Toc369717037

Step One:
As you make the entries in your research we will still be showing the following accounts different from the original SJI entry. Balancing the subsidiaries will throw the other accounts more out of balance between what did post and what would post. And since these entries came from the Accounts Receivable SJI Entries, there is still cleanup to do.

The Ledger posting is going to go to $80,000 after the reversed prepay is corrected. So now the work file will show $405.53 more in bank than what did post in the original SJI + prepay reversal correction.
The shortages are not amounting to:
Bank – Checking $405.53 Inventory – Feed - Pet $331.25Sales Tax $26.53Feed – Pet Sales $379.00Feed-Pet Food cost of sales $331.25

Anchor
_Toc369717038 _Toc369717038

Step Two:
Going back to how each document has a set of transaction codes that handle the debits and credits of that document.
Look at the shortages above. There is a common link to them. Since we are only looking at the Accounts Receivable package, this has to be an invoice. It is just missing the AR-Transaction code. Instead, there is a bank Transaction code.
So this would be an item invoice that was paid for by cash.

Anchor
_Toc369717039 _Toc369717039

Step Three:
This is an invoice, followed by a payment to the invoice. To find out what invoices, we will run an SJI work file LEDGER ACCOUNT DETAIL REPORT for one of these accounts and see what document number appears.SJI > Report Manager > Exec Work file Reports > Standard > Ledger account detail > set parameter for Sales Tax account 2060 to 2060 > date range for SJI period

There is only one document that makes up the sales tax amount.So now print the standard SJI Work File report called Transaction Analysis for that document number. SJI > Report Manager > Exec Work File Reports > Standard > Transaction Analysis > filter for this location and document number

This proves that there was another document keyed in the month AFTER the SJI's were created.

Anchor
_Toc369717040 _Toc369717040

Step Four:
Create a manual ledger entry to post this document.
Dr 1120 Accounts Receivable $405.53Dr 5340-0N Pet Food Cost of Sales $331.25Cr 1340-0N Pet Food Inventory $331.25Cr 2060-01 sales Tax $ 26.53Cr 4340-0N Pet Food Sales $ 379.00

Anchor
_Toc369717041 _Toc369717041

Step Five: This means that only our bank and A/R are different now but we can see the amount is $405.53 which would be a payment for the above invoice.
To verify, run the SJI Work File LEDGER ACCOUNT DETIAL for that bank code 1021-06. Look for the receipt amount of $405.53.SJI > Report Manager > Exec Work file Reports > Standard > Ledger account detail > set parameter for Sales Tax account 1021 TO 1021 > Detail code 06 to 06 > date range for SJI period

And in this report, you can see the backdated receipt of $405.53 that needs to be keyed into the ledger.

Anchor
_Toc369717042 _Toc369717042

Step Six:
Create a manual ledger entry to post this document.
Dr 1021-06 Cash Bank $405.53Cr – 1120 Accounts Receivable $405.53

...