Transactions Missing from Account Reconciliation in Sage 50

It’s not hard to guess why Sage 50 is extremely popular among the business community all over the world. It helps businesses and professionals accomplish their accounting tasks in a more efficient manner. Sage 50 is also appreciated for its user-friendly interface. Even a novice accountant can operate this software with utmost ease. However, as per the feedback received from a section of Sage users, they are finding an issue while performing bank reconciliation in Sage 50. They have informed us that certain transactions are missing from the account reconciliation or bank reconciliation window. In this blog, we are going to discuss why this issue occurs and how to fix it once and for all.
User Navigation
- Causes of Transactions Missing from Account Reconciliation In Sage 50
- How to Fix the issue of Transactions Missing from Account Reconciliation In Sage 50?
- Solution I: Verify the following details in Reconciliation & Deposit Window
- Solution II: Verify if certain Transactions affecting the Account for this Period
- Solution III: Verify if the General Ledger Mentions Correct Accounts for the Transactions
- Method IV: Check if Transactions were Posted during Bank Reconciliation
- Accounting Professionals & Specialized Experts
- Frequently Asked Questions
Here we go!
Causes of Transactions Missing from Account Reconciliation In Sage 50
The following points will tell you why you can’t find transactions in the account reconciliation of bank reconciliation window-
- If the date of the transaction is not matching with the reconciliation period.
- If the transaction is entered against the wrong account.
- If the type of transaction is not approved by a bank.
- If the start and end dates of a statement are the same
- If the transaction is grouped with other transactions
- If the transaction has been reconciled already
- If outstanding statements are not added after the reset of the bank reconciliation
How to Fix the issue of Transactions Missing from Account Reconciliation In Sage 50?
Here, we are providing multiple remedies to solve this issue-
Total Time: 35 minutes
Solution I: Verify the following details in Reconciliation & Deposit Window
🔹 Check if the correct account is selected.
🔹 If the Statement Start Date and bank statement start date is matching
🔹 If the Statement End Date is the same as that of your bank statement end date and is not matching with the Statement Start Date.
Solution II: Verify if certain Transactions affecting the Account for this Period
🔹 Go to the Reports section
🔹 Click Financials.
🔹 Choose Transactions by Account / General Ledger
🔹 Choose the account.
🔹 Make the Start and Finish dates the same as that mentioned in your bank reconciliation.
🔹 Checkmark the Corrections box
🔹 Click OK.
🔹 If you can see transactions on this report, run the Advanced Database Check.
🔹 In the General Ledger report, set the Finish date to the Latest Transaction Date ( which can be viewed in Setup >>Settings >>Company, Information)
🔹 If you can see transactions on this report, this company may not have any transactions for the chosen period
🔹 Please check if the incorrect transactions have been entered with the wrong dates, in the wrong company file
Solution III: Verify if the General Ledger Mentions Correct Accounts for the Transactions
🔹 Go to the Reports section
🔹 Click on Transaction Details /Journal Entries
🔹 Click All
🔹 Choose the correct year
🔹 Click on Date for Report By
🔹 Provide the correct Start Date and also the Finish Date
🔹 Click on Corrections for Show
🔹 Click OK
🔹 Verify if the correct accounts are mentioned in the transactions
Method IV: Check if Transactions were Posted during Bank Reconciliation
🔹 Go to the Account Reconciliation window (Reconciliation & Deposits)
🔹 Click Save
🔹 Close the Reconciliation & Deposits window
🔹 Open the Reconciliation & Deposits window again
🔹 Check if the transactions are showing now.
We hope, after going through the blog, you have received a fair idea of why certain transactions get missed from account reconciliation and how to fix this issue. If you are stuck at any point, you may contact 1800 964 3096 any experienced Sage professional.
Accounting Professionals & Specialized Experts
Want quick help from accounting software experts? Get in touch with our team members who can install, configure and configure your software for you. Proficient in fixing technical issues, they can help you quickly get back to work whenever you encounter an error in Sage software. Our team is available 24/7 365 days to assist you. To get in touch.
Frequently Asked Questions
How to Delete a Transaction in Sage 50
Please follow the steps below-
🔹 Navigate to the Task Menu
🔹 Click on Edit Register
🔹 Now, click to select the relevant bank account
🔹 Click Ok to proceed
🔹 Now, locate the transaction to delete, in the row that matches the transaction
🔹 Click to select the transaction to delete
🔹 Right-click on the black arrow for this transaction
🔹 Click on Delete Row
🔹 A prompt will pop up. Click yes to delete
🔹 Select Finish
🔹 Click Start to print the journal or if you want to save it as a file
🔹 You can post the reversing Cash Management entries with the General Ledger
🔹 After deleting the entries, you may need to delete the bank balances as well
How to Make an Account Inactive in Sage 50?
Please follow the steps given below-
🔹 Open Sage 50
🔹 Navigate to the Maintain menu
🔹 Click on Chart of Accounts.
🔹 The window named Maintain Chart of Accounts will come up on your screen
🔹 Enter/choose the account ID you wish to make inactive
🔹 To go to the list of existing accounts, click on the G/L Account ID field
🔹 Now type ?. Alternatively, you can click on the Lookup button.
🔹 Checkmark the Inactive box to the right of the selected Account ID
How to Unflag a Transaction Made in Sage 50?
Please follow the steps below-
🔹 Navigate to the navigation bar
🔹 Click on Transactions
🔹 Choose the required transaction
🔹 Click on Edit.
🔹 Unmark the Bank rec on the check box
🔹 Click Save
🔹 Click Yes
🔹 Navigate to the navigation bar again
🔹 Click on Bank accounts
🔹 Double-click on the bank account
🔹 Click Memo.
🔹 Double-click on Statements
🔹 Right-click on the statement to remove
🔹 Click Delete.
🔹 Click Save
🔹 Finally, click Close.
Post navigation
It can be quite annoying when you visit a website and encounter an error message such as "Page not ...
Are you facing issues while using journal entries in Sage 50? Are your entries not showing up in yo...
Sage 50 US Edition: Announcing Sage 50 2020.1 is the most upgraded version which is flexible to you...
Sage 50 is an accounting software widely used by businesses to manage their finances. However, it i...