Investigate transactions found by the Internal Accounting Review
How Do I...
Once transactions are found that meet an Internal Accounting Review
(IAR) check's
criteria, the transactions are listed in a table under the check name.
The steps that you take to investigate a transaction to figure out what
action to take vary depending upon the actual IAR
check. Below, we suggest ways to investigate transactions that have been
found by the Review.
Click the IAR check name to see the steps we recommend to investigate
transactions found by the IAR.
Purchases or bills that do not credit an accounts payable account
- Click the transaction that you want to investigate. The Purchases window appears displaying the transaction that you selected.
- Check the A/P Account that was selected for this transaction. (Click the magnifying glass button to see the account and account type.) If this is the account that you intended to use for this transaction, then no action is required. However, if you intended to select an A/P account, you can change the account now and save the
record.
Note: If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Sales or invoices that do not debit an accounts receivable account
- Click the transaction that you want to investigate. The Sales/Invoicing window appears displaying the transaction that you selected.
- Click the Journal button to see which accounts are being debited and credited for this transaction. Since we’re interested in which account is debited, find the debiting entry and check the account type. (Click the magnifying glass button to see the account and account type.)
- If this is the account that you intended to use for this transaction, then no action is required. However, if you intended to select an A/R account, you can change the account now and click OK. Then save the Sales/Invoice.
Note:
If no changes are made to the transaction, it will continue to display in the Internal Accounting Review.
- Close the window to return to the Internal Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Payments or checks that do not credit a cash account
- Click the transaction that you want to investigate. The Payments window appears displaying the transaction that you selected.
- Check the Cash account that was selected for this transaction. (Click the magnifying glass button to see the account and account type.) If this is the account that you intended to use for this transaction, then no action is required. However, if you intended to select a Cash account, you can change the account now and save the
record.
Note: If no changes are made to the transaction, it will continue to display in the Internal Accounting Review.
- Close the window to return to the Internal Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Receipts
or money received that does not debit a cash account
- Click the transaction that you want to investigate.
The Receive Money window appears displaying
the transaction that you selected.
- Check the Cash account that was selected for
this transaction. (Click the magnifying glass button to see the account
and account type.) If this is the account that you intended to use for
this transaction, then no action is required. However, if you intended
to select a Cash account, you can change the account now and save the
record.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Transactions
that debit and credit the same general ledger account
- Click the transaction that you want to investigate.
The window that appears depends on the type of transaction that you clicked.
- Select the Journal
button from the toolbar to see which account is being debit and credited
for this transaction.
- If these are the accounts that you intended
to use for this transaction, then no action is required. However, if you
intended to select different accounts, you can change the account now
and save the record.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Possible
duplicate transactions of the same type
- Click the transaction that you want to investigate.
The window that appears depends on the type of transaction that you clicked.
- Examine the transaction to determine whether
or not it’s a duplicate.
- If the transaction is not a duplicate and
is set up as you intended, then no action is required. However, if the
transaction is a duplicate, you can either edit or delete the transaction
now and save.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Vendor
invoices or bills from prior periods that have not been received
- Click the transaction that you want to investigate.
The Purchases window appears displaying
the transaction that you selected.
- Notice that the Waiting
on Bill checkbox is selected. Examine the transaction to determine
whether or not you have actually received a bill.
- If you have not received a bill, then no action
in Sage 50 is required. (You may need to call the vendor see if a bill
has been sent.) However, if you have received a bill, clear the Waiting
on Bill checkbox now and save.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Transactions
entered in the future
- Click the transaction that you want to investigate.
The window that appears depends on the type of transaction that you clicked.
- Examine the transaction to determine whether
or not it’s a valid transaction.
- If the transaction is as you intended, then
no action is required. However, if the transaction was accidentally entered
in the future, you can either edit or delete the transaction now and save.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Transactions
posted to inactive records
- Before you click the transaction that you
want to investigate, look in the last column of the table to determine
the inactive record type and ID.
- Click the transaction that you want to investigate.
The window that appears depends on the type of transaction that you clicked.
- Examine the transaction to determine whether
or not you intended to use this inactive record.
- If the transaction is as you intended, then
no action is required. However, if you accidentally selected an inactive
record, you can either edit or delete the transaction now and save. If
this record should not be marked as inactive, go to the appropriate maintenance
window and clear the Inactive record.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Un-reconciled cash accounts
- Click the transaction that you want to investigate.
The Account Reconciliation window
appears displaying the account that you clicked.
- Examine the transaction(s)
listed for this account to determine whether or not they have cleared.
- If the transactions have not cleared, then
no action is required. However, if transactions are listed that have cleared,
you can mark them as cleared now and click OK. If
there are no transactions listed on the register, then either the account
didn’t
have any reconciliation activity for the reporting period or this account
is not used. (These accounts will continue to appear in the IAR. If an
account is listed that you don’t
use and you don’t want it to continue to appear in the IAR, you might
consider deleting the account.)
Note:
If all transactions in the register are not cleared, then the account
will continue to display in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Inventory
items that default to duplicate general ledger accounts
- Before you click the transaction that you
want to investigate, look at the last three columns of the table to determine
the account that may be a duplicate.
- Click the transaction that you want to investigate.
The Maintain Inventory Items window
appears displaying the inventory item that you clicked.
- Examine the inventory item record to determine
which accounts were selected for GL Sales, GL
Inventory, and GL Cost of Sales
accounts.
- If the accounts are as you intended, then
no action is required. However, if you accidentally selected the wrong
account type, you can change the accounts now and save.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Out
of sequence checks
- Click the transaction that you want to investigate.
The Check Register report appears
displaying the account that has out of sequence checks.
- Review the list to determine if you intentionally
skipped the check numbers.
- If you intentionally skipped the check numbers,
then no action may be required. However, if you didn’t want to skip the
check numbers, you may need to investigate further. (You can double-click
any transaction on the Check Register report to see the transaction detail.)
In the Payments window you can enter another check number for a transaction
if the check number was entered in error.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
Accounts
receivable accounts that are out of balance with the aged receivables
report
To investigate transactions found by this check, we suggest
that you try the following steps.
- Before you click a transaction
to drill down to the Aged Receivables report, determine if the accounts
that are listed are applicable accounts. If the accounts are not applicable
to your business, you can choose not to have them included in the Internal
Accounting Review. Click the plus
button next to the Select your Accounts
Receivable account and select the A/R accounts that you use in
your business.
- If the accounts are applicable,
verify for the current period, that there are no sales or invoices that
do not debit
an A/R account. (This is identified in the second IAR check.) If transactions
exist, resolve them first.
- If the A/R balance and
the Aged Receivables report are still not balanced, click the transaction
that was found to open the Aged Receivables report. Examine the report
to see if you can find what is causing the imbalance.
- Finally, we recommend
that you run the General Ledger report and filter on either all A/R accounts
or the specific account in question. Examine the report and compare it
with the Aged Receivables report to try to find the discrepancy. If the
issue isn't resolved, you may need to track back to find the exact date
of imbalance.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- After you’ve
made a change, click the Refresh
button to update the information.
Accounts
payables accounts
that are out of balance with the aged payables
report
To investigate transactions found by this check, we suggest
that you try the following steps.
- Before you click a transaction
to drill down to the Aged Payables report, determine if the accounts that
are listed are applicable accounts. If the accounts are not applicable
to your business, you can choose not to have them included in the Internal
Accounting Review. Click the plus
button next to the Select your Accounts
Payable account and select the A/P accounts that you use in your
business.
- If the accounts are applicable,
verify for the current period, that there are no purchases or bills that
do not credit
an A/P account. (This is identified in the first IAR check.) If transactions
exist, resolve them first.
- If the A/P balance and
the Aged Payables report are still not balanced, click the transaction
that was found to open the Aged Payables report. Examine the report to
see if you can find what is causing the imbalance.
- Finally, we recommend
that you run the General Ledger report and filter on either all A/P accounts
or the specific account in question. Examine the report and compare it
with the Aged Payables report to try to find the discrepancy. If the issue
isn't resolved, you may need to track back to find the exact date of imbalance.
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- After you’ve
made a change, click the Refresh
button to update the information.
Possible duplicate paychecks for an employee within a pay period
- Before you click the transaction that you
want to investigate, look at the paychecks that may be duplicates. Potentially
duplicate paychecks are grouped together.
- Click the transaction that you want to investigate.
(We recommend that you investigate each of the duplicate transactions.)
The Payroll Entry window appears
displaying the transaction that you selected.
- Examine the transaction to determine whether
or not you intended to enter this paycheck.
- If the transaction is as you intended, then
no action is required. However, if you accidentally entered this paycheck,
you can either edit or delete the transaction now and save. (Repeat steps
2-4 for each duplicate that was found.)
Note:
If no changes are made to the transaction, it will continue to display
in the Internal Accounting Review.
- Close the window to return to the Internal
Accounting Review page.
- After you’ve made a change, click the Refresh button to update the information.
What do you want to do next?