Debtors & Creditors vs Balance Sheet

Debtors & Creditors vs Balance Sheet

  1. To start, run a Balance Sheet to look at the state of the accounts, as of the end of January 2019

  1. Once you have input the report credentials as seen above, it will provide you with the Balance Sheet.
  2. We can now compare the figures witnessed in the Creditors and Debtors Control fields in the Balance Sheet by comparing with a Creditors and Debtors report, to cover the same period.
  3. The two images below, show you how to configure the report to see the Debtors report (highlights in green) and the creditors report (highlighted in red):

  1. Once you have configured the report as shown above, select the “Retrospective” tab and input the details below, to generate your report for the same period as the Balance Sheet:

  1. You will now be provided with a report, based upon whether you have configured it for the Debtors or Creditors. (This process will need to be completed twice, as you can only run the Creditors/Debtors once at a time).
  2. Once you have the report, the value at the very end of it should tally with the corresponding field in the Balance Sheet…
Debtor Report:


Balance Sheet:

  1. If these figures do not match, you will need to raise a ticket for Durell Support to investigate.

    • Related Articles

    • Aged Debtors Creditors - Insurers

      From the Durell homepage click on “Accounts” Then “Aged Debtors” Use the configuration as shown below Click on the ‘Retrospective’ tab Leave date blank for all or input date for retrospective report Press “OK”

    • Aged Debtors Creditors - Insurers

      From the Durell homepage click on “Accounts” Then “Aged Debtors” Use the configuration as shown below Click on the ‘Retrospective’ tab Leave date blank for all or input date for retrospective report Press “OK”

    • Opening Balance or Bank Balance Adjustment

      How to put in an opening balance. This should only be done to put in a balance when starting a new bank account when you are transferring in an amount from a previous client account  or if you are making an adjustment to your bank balance as it ...

    • Adding Nominal to the Trial Balance

      From the Durell homepage click on “Accounts” Then “Reports” Finally “User Defined” The following nominals in the “Sales Ledger” and “Purchase Ledger” sections will need to be added back into the report Click on “Save” and Trial Balance will now be ...

    • Basic Write Off of Unpaid Policy (General)

      To write off an unpaid balance of a policy, the best procedure will be to create a negative MTA for the remaining balance. In the example we will use below, our unpaid balance is £50. Begin by creating an MTA. You do not need to worry about any of ...