Bookmark this page Print this page

Reports, Accounts, RMAR BALANCE SHEET

Every Durell system is supplied with a standard Balance Sheet report, which can be edited via the User-defined Report Writer. This can be run either via the User-defined Reports button or via its own button on the Accounts Reports menu, as shown below...

The RMAR version of this report can only be run from within the User-defined Reports screen and differs in layout, although it is similar in principle. Because users are likely to have set-up their own nominal accounts (e.g. PHON for Telephone Charges, etc) that Durell may not have pre-defined, the RMAR reports are supplied just as basic layouts into which you must add your own nominal accounts, as described below.

As far as possible this Help lists the expected nominal account names and codes, but if you’ve added any of your own, or have changed the ones originally supplied, then you may have to make allowances for them in the following notes.

 

Starting from the Durell Main Menu...

  • Click the “Accounts” button
  • Click the “Reports” button
  • Click the “User-defined” button
  • Use the “Report name” dropdown to select “RMAR – BALANCE SHEET (TEMPLATE)”, as shown below...
  • Edit the report name (e.g. to “RMAR BALANCE SHEET”)
  • Click the red “Save” icon on the toolbar (looks like a red floppy disk)
  • In the Report Name dropdown you’ll now be able to see both the original “template” version and your renamed one
  • Re-select your renamed version (i.e. so that the original “template” version is retained unchanged)
  • Now continue with one of the following sections below.....
  • Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Control accounts”
  • o Click the “Debtors” heading on the left, as shown above

    § In the “Available” window on the right double-click “Debtors Control” (DEBT) plus any other Directors Loan accounts

    o Click the “Cash at bank and in hand” heading on the left

    § In the “Available” window on the right double-click the four accounts for Payments in Advance and Not Banked, plus Receipts in Advance and Not Banked (PMTA, PMTN, RCTA & RCTN)

    § Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Banks”

    § In the “Available” window on the right double-click the line for “All Banks”

    o Click the “Other Liabilities” heading on the left

    § Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Control Accounts”

    § In the “Available” window on the right double-click “Creditors Control” (CRED) plus the “VAT Control” (VAT) if relevant

    o Click the “Ordinary Share Capital” heading on the left

    § In the “Available” window on the right double-click any Share Holding accounts you may have set up

    o Click the “Profit & Loss Account” heading on the left

    § In the “Available” window on the right double-click the Profit & Loss Brought Forward (PLBF) account

    o Click the “Fixed Assets” heading on the left

    § In the “Available” window on the right double-click any Assets accounts you may have set up

    By now you should have selected ALL the bank accounts and ALL of the individual control accounts. If any are still remaining you should allocate them to one of the headings, above. The only exceptions to this are for General Insurance, where the following control accounts should NOT be allocated to headings in this report...

  • Adviser Commission in Suspense (CADS)
  • Adviser Commission Transferable (CADT)
  • Introducer Commission in Suspense (CINS)
  • Introducer Commission Transferable (CINT)
  • General Commission in Suspense (G*CS)
  • General Commission Transferable (G*CT)
  • General Charges in Suspense (GXI*)
  • General Charges Transferable (GXIA)
  • This is because these are not true control accounts. Although they behave technically like control accounts they should be included in the Profit & Loss report along with the other nominal accounts.

    Saving

    At any point you can save your report by clicking the “Save” button on the toolbar (looks like a red floppy disk). You should do this frequently while working, and then again when you’ve finished.

    Setting Options

    After adding all of the nominal and control accounts, as described above, you MUST CHECK THE FOLLOWING OPTIONS...

  • Click the “Signpost” button
  • The option to “Include opening balances” MUST BE TICKED. If it is not ticked then click it to add the tick
  • You may optionally choose to put ticks against “Hide nominal codes” and “Keep in alphabetic order”
  • Click Totals and check that there is a tick against “Grand totals”, which is essential
  • Save these settings by clicking the “Save” button
  • Printing

    To print the report...

  • Select it from the “Report Name” dropdown
  • Click “File” (at the top left of the screen)
  • Click “Print”
  • Click “Report”
  • Select the year and period
  • Click “OK”