Reports, Accounts, RMAR Profit and Loss

Reports, Accounts, RMAR PROFIT & LOSS

Every Durell system is supplied with a standard Profit & Loss 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 – PROFIT AND LOSS (TEMPLATE)”, as shown below...

· Edit the report name (e.g. to “RMAR PROFIT AND LOSS”)

· 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.....

If your business only deals with Life, Mortgages, Pensions & Investments

· Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Sales Ledger”

o Click the “Non Investment” heading on the left, as shown above

§ In the “Available” window on the right double-click the three “Life” nominals for indemnity, non-indemnity and renewal (LCEN, LCEA & LCXR)

o Click the “Investment” heading on the left

§ In the “Available” window on the right double-click the three “Investment” nominals for indemnity, non-indemnity and renewal, then double-click the three “Pensions” nominals for indemnity, non-indemnity and renewal (ICEN, ICEA & ICXR then PCEN, PCEA & PCXR)

o Click the “Fees” heading on the left

§ In the “Available” window on the right double-click the two “Fees” nominals for Mortgage Fees and Consultancy Fees (MFEE & CFEE)

· Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Purchase Ledger”

o Click the “Introducers” heading on the left

§ In the “Available” window on the right double-click the two accounts for “Pay-away, Introducers” and “Pay-away, Advisers” (CADV & CINT)

o Click the “Expenses” heading on the left

§ In the “Available” window on the right double-click the all the purchase ledger accounts except any that you may have set up for the payment of dividends

o Click the “Dividends” heading on the left

§ In the “Available” window on the right double-click all purchase ledger accounts that you may have set up for the payment of dividends

If your business only deals with General Insurance

· Click the sales heading “Investment” and in the “Edit heading” box change it to say “Other Revenue”

· Click the “Non Investment” heading on the left, as shown above

o Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Sales Ledger”

§ In the “Available” window on the right double-click the “General” nominals for commission, premiums and returned commission (GCEA, GPRM & GCXW)

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

§ In the “Available” window on the right double-click the “General” nominals for commission in suspense and transferable (G*CS & G*CT)

· Click the “Fees” heading on the left

o Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Sales Ledger”

§ In the “Available” window on the right double-click the “Fees” and “Charges” nominals (GXIE & CFEE)

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

§ In the “Available” window on the right double-click the two “Charges” nominals for suspense and transferable (GXI* & GXIA)

· Click the “Other Revenue” heading on the left

o Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Sales Ledger”

§ In the “Available” window on the right double-click any other nominals you may have set up for other sources of revenue

· Click the “Introducers” heading on the left

§ In the “Available” window on the right double-click the two accounts for “Pay-away, Introducers” and “Pay-away, Advisers” (CADV & CINT)

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

§ In the “Available” window on the right double-click the four nominals for pay-aways in suspense and transferable (CINS & CINT plus CADS & CADT)

· Click the “Expenses” heading on the left

§ In the “Available” window on the right double-click the all the purchase ledger accounts except any that you may have set up for the payment of dividends

· Click the “Dividends” heading on the left

o Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Purchase Ledger”

§ In the “Available” window on the right double-click all purchase ledger accounts that you may have set up for the payment of dividends

If your business deals with both Life, Mortgages & Investments AND General Insurance

· Click the heading “Sales”

· Click the button “Add sub heading”

· In the “Edit heading” box change this new heading to say “Other Revenue”

· Now go through the two sections above, adding all the nominal accounts for both Life and General business

Any Other Nominal Accounts

After you’ve completed the instructions above...

· Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Sales Ledger”

o If any accounts are still listed in the “Available” box (other than “All sales nominals”) then select a suitable sales heading on the left and double-click those nominals on the right to add them to it.

· Use the “Add Nominals / Controls / Banks” dropdown on the right to select “Purchase Ledger”

o If any accounts are still listed in the “Available” box (other than “All purchase nominals”) then select the “Expenses” heading on the left and double-click those nominals on the right to add them to it.

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 NOT BE TICKED. If it is ticked then click it to remove 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