Clearing Checks and Deposits in Sage 50 (QuickBooks Conversion)

You will need to manually reconcile your bank accounts in Sage 50. Follow these steps to reconcile your bank account.

In QuickBooks, modify and print the Check Detail and Deposit Detail reports.

  1. From the Reports menu, select Banking and then Check Detail.
  2. Click the Customize Report or Modify Report button.
  3. For Report and Date Range, change the date to All.
  4. In Columns, select Clr so that you can easily distinguish the cleared checks on the report.
  5. Click OK.
  6. Print the report so that you can reconcile the accounts in Sage 50.
  7. Repeat steps 1-6 for the Deposit Detail Report.

Follow these steps to reconcile bank accounts in Sage 50.

  1. From the Tasks menu, select Account Reconciliation.
  2. Select an Account to Reconcile from the list. (You need to only reconcile Cash Accounts, usually Savings and Checking.)
  3. For the Statement Date, select the last date of the month before the day you converted to Sage 50. For example if you converted on June 20, 2019, you would select May 31, 2019 as the Statement Date.
  4. Using the Check and Deposit Detail reports, mark all of the checks and deposits that have cleared, by selecting the check box in the Status column.

    5. Tip: You can do this more quickly using the Multiple button. This will allow you to select a date range or reference number range and clear the entire group quickly.

  5. Finally, enter the Unreconciled Difference amount that displays at the bottom of the screen into the Statement Ending Balance field. This entry will ensure that future account reconciliation reports are accurate.
  6. Click OK.
  7. Repeat steps 1-6 for each bank account that you have. We also recommend that you reconcile Undeposited Funds Account so that your Account Reconciliation Reports will be accurate.