Sage Not Showing All Transactions

The details of each transaction you submit into Sage 50 cloud Accounts are kept in a list called the audit trail. When conducting their investigations, auditors frequently ask for access to the audit trail, which is an exhaustive record of all transaction activity.

An explanation of each transaction type that appears on the audit trail is given in this article.

Type of Transactions in Sage:

1.  Additional stock transactions – When working with stock records, there are a variety of transaction types available, including AI – Adjustment in and AO – Adjustment out.

2.  Additional project transactions – When working with projects, there are two additional project-only transactions that may appear on your project activity: Project Charge (CD) and Project Credit (CC).

The most common Sage Transaction errors are:

Error 1: Bank reconciliation is missing transactions

Errors that frequently occur with Sage 50 Transactions:

1. While performing a bank reconciliation, you can only see transactions from the month you are reconciling up to date X.
2. You ought to be able to see every transaction for this month.
3. The general ledger report contains the transactions. But it doesn’t appear in the reconciliation.
4. Transactions are missing from the bank reconciliation.
5. After the bank reconciliation has been reset, transactions are missing.
6. missing transactions from the bank reconciliation.
7. While doing the bank reconciliation, you uploaded transactions; nevertheless, the window is not refreshing the list to reflect these new transactions.

The following are the causes of these errors:

1. The dates on the transactions are inaccurate.
2. The start and end dates of the statement are the same.
3. After the bank reconciliation was reset, outstanding transactions were not included.

Resolution of Bank reconciliation is missing transactions

Before you begin:

1. If the transaction does not appear in the General Ledger report, it is possible that you are not using the correct file.
2. Do not use this KB and instead consult KB 10270. Where can I find my company file? Instead

Method 1: In the Reconciliation & Deposit window, double-check the following

1. The correct account has been chosen.
2. The Statement Start Date corresponds to the start date of your bank statement. You cannot enter or amend the start date unless this is your first reconciliation.
3. The Statement End Date is different from the Statement Start Date and coincides with the end of your bank statement.

Method 2: Confirm that the account has truly been affected by transactions during this time

1. Select Financials, then Reports.
2. Select General Ledger, commonly known as Transactions by Account.
3. choosing the account.
4. The Start and Finish dates should be set to coincide with your bank reconciliation.
5. Check the box next to Corrections.
6. Choose OK.
7. Run the Advanced Database Check if this report contains any transactions. Continue with article 40861 Performing an Advanced Database Check
8. Make that the Finish date on the General Ledger report is set to the Most Recent Transaction Date that is specified in Setup, Settings, Company, and Information.
9. If there are no transactions on the report, this company file has no transactions for the given time.
10. Please check to see whether the transactions were recorded improperly, in the wrong business file, or were not entered at all.

Method 3: Check that the accounts in the General Ledger report are valid:

1. Choose Reports, then Transaction Details or Journal Entries, and finally All.
2. Choose the proper year.
3. Enter the right Start Date and Finish Date for the Report
4. Select OK to Show Corrections
5. Check the accounts against the transactions.
6. If the transaction does not affect the AP or AR account but rather the account you are reconciling, you can change it to Cash or Cheque or utilize the Receipt or Payment module as appropriate.

Method 4: If transactions were submitted while bank reconciliation was being performed:

1. Click the Save button in the Account Reconciliation box (Reconciliation & Deposits).
2. Shut off the Reconciliation & Deposits window.
3. Reopen the Reconciliation & Deposits window and check to see if the transactions are again visible.

Method 5: Missing transactions after completing bank reconciliation reset:

1. Select Account Reconciliation Report under Reports, Banking, after the business has opened.
2. Use a summary report with details on outstanding transactions.
3. Set the Start date and Finish date to the Statement End date of the prior period that was reconciled after choosing the appropriate bank account. For instance, if you’re reconciling January 1 to January 31, use December 31 as the Report’s Start and Finish Dates.
4. To save this report, choose to print it or open it in Excel after clicking OK to read the report.
5. Open the original company’s Account Reconciliation window.
6. As soon as the account has been chosen, click the Add Prior Outstanding option.
7. Restore the backup into a new business that was created prior to doing the bank reconciliation reset.

Error 2: Why doesn’t anything is showing in my bank reconciliation window?

Cause:

1. Misleading Statement Beginning Date or Statement End Date
2. Transactions have been registered as historical when in History mode, however Prior Outstanding has not yet been added.

Option I: Confirm the date

1. Check that Sage 50 has recorded the bank transaction on the appropriate date.
2. The transaction date must be on the Statement or earlier. The bank rec module’s end date

Option II: If there are unfinished transactions from past months that have not yet been cleared.

1. Choose “Add Prior Outstanding” from the menu.
2. Choose “Show Resolved Transaction On or After” and enter the date of the earliest transaction to be included.
3. The list of transactions from the Resolve Transactions will appear when you tab to the following field.
4. Click the Add button after choosing the transaction to be added.
5. If you are unable to locate a transaction that is still open, you can manually input the open transactions by selecting the Insert Outstanding button.
6. Input OK.
7. The transactions that are still open and running will then appear in the Reconciliation & Deposits window’s Transactions tab.

Choice III: Unless there is any unfinished business from the preceding months

1. Select “Add Prior Outstanding” from the menu.
2. The Transactions tab of the Reconciliation & Deposits window will display the most recent transactions when you click OK.
3. Check to see if the Statement End Date is recorded with the correct currency if this is not your first bank reconciliation.

Error 3: Transaction/Deposit not showing in Account Reconciliation

Resolution of Transaction/Deposit not showing in Account Reconciliation

Note: It is advised that you make a backup of your Sage 50 data before moving forward. Please see the following link: How Do I Create a Backup?

Solution 1: Ascertain whether the transaction is damaged.

1. Select Deposits or Receipts after choosing Lists, Customers & Sales.
2. Find the deposit ticket or receipt that account reconciliation is missing.
3. Open the deposit ticket or receipt and make a note of the necessary details, or print the transaction.
4. Remove the deposit receipt or ticket.
5. Make a new deposit ticket or receipt.
6. Press Save.
7. Check to see if the deposit appears in the account reconciliation.

Solution 2: Show All Deposits and Bank Credits

1. At the top of the Account Reconciliation box, change the Show option to All or All, Deposits and Bank Credits First.
2. Check that the correct Account to Reconcile is chosen.
3. Check to see if the deposit was posted to the correct account.
4. If you still can’t find it, go to the top and click the Find symbol.
5. Fill in the Deposit ticket ID number.
6. Next, click.
7. If the deposit is found, it will be marked in the transaction list.

---

FAQ

---

1. Why am I unable to locate a transaction in the window for bank reconciliation?

The following factors can occur when a transaction is missing from the Bank Reconcile window: Date – The transaction’s date does not fall inside the reconciling window. The transaction was recorded against the incorrect bank account, or improper bank. This kind of transaction is not one that is listed in a bank.

2. Why don’t changes appear in the general ledger?

The modifications do not appear in the general ledger when we pull it up. Transactions from interacting programs are absent in General Ledger. In the General Ledger new file, the entries are not posted. Interfacing entries are only made when payments for receipts are received, and the accounting technique is cash basis.