Difference between revisions of "Accounts Module (Administrator guide)"

From Charitylog Manual
Jump to: navigation, search
(Invoice Layouts)
 
(62 intermediate revisions by 4 users not shown)
Line 11: Line 11:
 
* Automatically generate invoices for club/clinic activity (when using the Clubs and Clinics module), support work (when using the Support Worker Module), and handyperson services (using the Handyperson module).
 
* Automatically generate invoices for club/clinic activity (when using the Clubs and Clinics module), support work (when using the Support Worker Module), and handyperson services (using the Handyperson module).
 
* Create invoices to the client directly, or invoice a funder/organisation on their behalf.
 
* Create invoices to the client directly, or invoice a funder/organisation on their behalf.
* Print invoices directly from Charitylog.
+
* Print invoices directly from the system.
* Export invoices directly from Charitylog to the industry-standard Sage Line 50 accounting package, with department and nominal codes automatically assigned.
+
* Export invoices directly from the system to the industry-standard Sage Line 50 accounting package, with department and nominal codes automatically assigned.
  
==Overview of the Accounts module==
+
===Accounts module warning===
  
The accounts module is fairly separate to the rest of the system, which from the point of view of setup is a good thing, because end users don't usually have to worry about it. Usually, beside any activity which can be invoiced for, there will be a button which looks like a pile of coins. Clicking on this will let you see which charge rate is being used for the activity. In some cases there is a drop-down list of the available rates.
+
It is important that invoices are not created by two different system users at the same time. This would lead to errors in invoice numbering. Therefore, you may see a warning when you try and access accounting features, to make sure that the invoicing process is not in use elsewhere. If you know you are the only person using invoicing at that time, you can ignore the warning and continue.
  
There is a lot of setup to be done for the accounts module to work correctly, but once this is done, there is minimal ongoing work, apart from printing the invoices and exporting the data.
+
==Setup of the Accounts module==
  
The accounts module is intended to be used to invoice for work once it has actually been carried out, but with some careful thought, it can also be used to invoice for work in advance. Working out the best way to do this can be tricky and so you should discuss this with your assigned Charitylog trainer, and with the support department.
+
Before starting to use the accounts module, there are a few things that need setting up.
  
The accounts module can currently be applied to Club & Clinic activity, Support Worker work, or Handyperson activity. '''Clubs & Clinics''' is part of the Charitylog core; '''Support Worker''' and '''Handyperson''' are two of the available add-on modules for Charitylog. You should have good grasp of what these modules can do before setting up the accounts module to work with them. If you need to invoice for other activity, such as volunteer assignments, please give the support department a call. We plan to extend the accounts module at some point, and we depend on customer feedback to let us know what we need to develop.
+
===Invoice Layouts===
  
This flow chart shows the complete process, which we will use as the basis for this chapter.
+
Click the "Invoice Layouts" menu item, in the "General Accounts Setup" submenu.
  
  
[[File:A_accounts_chart1.png|border]]
+
[[File:Clog_invoice_layouts.png]]
  
  
===Example set of nominal/department codes===
+
This will take you to a screen displaying the invoice layouts available. Currently the system ships with five standard layouts, but there is scope to add to these  - please get in touch if you need a different layout.
  
As you set up the accounts module, you will need to enter department and nominal codes, which are a way of categorising activity and associated money. We will use the following set of example codes, and refer back to them throughout the guide.
 
  
'''Department codes'''
+
[[File:A_accounts_30.png|border]]
  
Daycare (private clients): 10
 
Daycare (council clients): 20
 
  
'''Nominal codes'''
+
You do have some editing control, though - click the "Edit" button to edit a layout. Here the standard layout is shown.
  
General/other: 1000
 
Fixed charges and administration costs: 5000
 
Travel time: 7000
 
Mileage: 6000
 
Client mileage: 8000
 
  
==Assigning accounts codes==
+
[[File:Clog_edit_invoice_layout.png|900px]]
  
The first thing you will need to do as part of the setup of the Accounts module is to assign customer IDs to anybody who is going to receive an invoice. You may already have an internal system for accounts codes, or they may be provided for you by a funding body.
 
  
On the client details screen, there is a space for "Accounts code" on the Personal Details tab:
+
You can set standard text, and a block of text to print on a following page to each invoice (this is useful for involved terms and conditions, for example). You can also specify image files (an absolute Web path) to print on your invoices. This is a good way to get your standard letterhead or graphics on your invoices.
  
[[File:A_accounts_1.png|border]]
+
===Invoicing Settings===
  
For funders, there is a similar field on the "General Details" tab of the Funder Details screen.
+
Click the [[Invoicing_Settings|Invoicing Settings]] menu item, in the "Invoicing" submenu.
  
[[File:A_accounts_2.png|border]]
 
  
It is in a similar place on the Organisation Details screen.
+
[[File:A_accounts_32.png|border]]
  
===Automatic accounts codes for people on your Charitylog system===
 
  
If you do not have a preset system for assigning accounts codes, Charitylog will let you use '''People/Organisation IDs''' as your accounts codes, with a prefix if you want to apply one. This can be done in [[Operational Rules]].
+
This screen will let you edit;
  
==Cost Centres==
+
* Last used invoice numbers - very useful for starting your invoicing with the system where a previous system stopped, rather than having to begin from 0.
 +
* Which standard layout to use for each type of activity.
 +
* Number of days until payment is due.
  
Creating the cost centres is where you say how much is going to be charged for various things, and assign your department and nominal codes. There are separate cost centres for Handyperson, Support Worker and Clubs & Clinics. We will deal with them in turn.
 
  
===Cost Centres for Clubs & Clinics===
 
  
The Accounts menu (in standard form) has four submenus;
+
[[File:Inv_parameters.PNG]]
  
* Invoicing (containing the menu items for creating, printing and exporting your invoices)
+
===Payment Methods===
* Support Accounts Setup (for setting up Support Worker-related accounting)
 
* HP Accounts Setup (for setting up Handyperson-related accounting)
 
* General Accounts Setup (for setting up general, i.e. Clubs And Clinics, accounting)
 
  
The menu item for Club and Clinic cost centres is in the "General Accounts Setup" submenu.
+
Click the "Payment Methods" menu item, in the "General Accounts Setup" submenu.
  
  
[[File:A_accounts_3.png|border]]
+
[[File:PayMeth.PNG|border]]
  
  
Clicking this menu item will take you to a screen where you can see the cost centres currently set up on your system, and enter new ones.
+
Here you can set up custom payment methods, which can be used for particular customers (for example, if you have a few customers that pay cash, and the rest pay by cheque). This is only necessary if you want different text to be carried onto the invoice for a particular method - for example, you might want "Please only pay cash into our account at the bank directly. Please do not bring cash into our office" or similar for a cash payment method.
  
 +
If you don't need different payment methods, you can ignore this.
  
[[File:A_accounts_4.png|border]]
+
==Overview of the Accounts module==
  
 +
The accounts module is fairly separate to the rest of the system, which from the point of view of setup is a good thing, because end users don't usually have to worry about it. Usually, beside any activity which can be invoiced for, there will be a button which looks like a pile of coins. Clicking on this will let you see which charge rate is being used for the activity. In some cases there is a drop-down list of the available rates. There is a lot of setup to be done for the accounts module to work correctly, but once this is done, there is minimal ongoing work, apart from printing the invoices and exporting the data.
  
Click "Create New Cost Centre" and you will be taken to the following screen.
+
Occasionally you may see an error message like the following:
  
  
[[File:A_accounts_5.png|790px|border]]
+
[[File:A_accounts_21.png|border]]
  
  
''These screens, within the "Cost Centres" menu item, apply to all accounts activity.''
+
Accounts is one area of the system where it is very important that there is only one person creating invoices at a time. Therefore the system is quite careful about letting more than one person use it, and will show this warning when it thinks there is a clash of users. If the warning relates to your own username, feel free to click "Click here" (as long as you aren't using invoice processing in several tabs at once, which is not advised). If the warning relates to another user, you should stop and contact that user to make sure that only one of you is using the invoicing section at once.
  
The main purpose of the cost centre is to say who will pay for what, and to assign nominal and department codes to the activity. When specifying who pays, you will see a drop-down list of the people who have accounts codes set up on your system. When specifying the department and nominal codes; your finance office will be able to advise you on what to use. [[Accounts_Module_(Administrator_guide)#Example_set_of_nominal.2Fdepartment_codes|Click here to see the example set.]]
+
The accounts module is intended to be used to invoice for work once it has actually been carried out, but with some careful thought, it can also be used to invoice for work in advance. Working out the best way to do this can be tricky and so you should discuss this with your assigned system trainer, and with the support department.
  
If you're simply using Charitylog to create your invoices, but not exporting to another accounts system, you may simply want to use placeholders like "dep" and "nom". You do need to enter something; the system will not create invoices with missing codes, unless you specifically tell it to do so.
+
The accounts module can currently be applied to Club & Clinic activity, Support Worker work, or Handyperson activity. '''Clubs & Clinics''' is part of the core system; '''Support Worker''' and '''Handyperson''' are two of the available add-on modules for the system. You should have good grasp of what these modules can do before setting up the accounts module to work with them. If you need to invoice for other activity, such as volunteer assignments, please give the support department a call. We plan to extend the accounts module at some point, and we depend on customer feedback to let us know what we need to develop.
  
To set up the codes, it makes sense to do so with a scenario in mind, so here is our example scenario.
+
This flow chart shows the complete process, which we will use as the basis for this chapter.
  
Our organisation runs daycare centres, and uses Charitylog's Clubs and Clinics module to manage attendance at them.
 
Attendance at the centres is chargeable, but at two different rates.
 
Private clients (that pay for themselves) pay £20 per day.
 
Council clients pay £25 per day.
 
  
So there are two different people receiving invoices, and therefore you are going to need two Cost Centres. (It may turn out later that more are needed, to deal with other things, but a minimum of two will be required if we have two sets of people being invoiced.)
+
[[File:A_accounts_chart1.png|border]]
  
''We will also need two charge rates, as there are two different amounts to be paid for the same activity.''
 
  
An example cost centre might look like this:
+
===Example set of nominal/department codes===
  
 +
As you set up the accounts module, you will need to enter department and nominal codes, which are a way of categorising activity and associated money. We will use the following set of example codes, and refer back to them throughout the guide.
  
[[File:A_accounts_6.png|790px|border]]
+
'''Department codes'''
  
 +
Daycare (private clients): 10
 +
Daycare (council clients): 20
  
The council one will be set up in a similar fashion, but using nominal code 20 for everything. Once these are set up you will have two new cost centres on your system ready for use, as shown. You can now move on to setting up charge rates.
+
'''Nominal codes'''
  
 +
General/other: 1000
 +
Fixed charges and administration costs: 5000
 +
Travel time: 7000
 +
Mileage: 6000
 +
Client mileage: 8000
  
[[File:A_accounts_7.png|border]]
+
==Assigning accounts codes==
  
 +
The first thing you will need to do as part of the setup of the Accounts module is to assign customer IDs to anybody who is going to receive an invoice. You may already have an internal system for accounts codes, or they may be provided for you by a funding body.
  
==General Charge Rates==
+
On the client details screen, there is a space for "Accounts code" on the Personal Details tab:
  
Click on "General Charge Rates" in the General Accounts Setup submenu, which will take you to the following screen:
+
[[File:A_accounts_1.png|border]]
  
 +
For funders, there is a similar field on the "General Details" tab of the Funder Details screen.
  
[[File:A_accounts_8.png|border]]
+
[[File:A_accounts_2.png|border]]
  
 +
It is in a similar place on the Organisation Details screen.
  
As you can see, there are two rates already set up, but we are going to use new ones. The charge rate for private clients might look like this:
+
===Automatic accounts codes for people on your system===
 
 
 
 
[[File:A_accounts_9.png|border]]
 
 
 
 
 
* The client will be charged £20 for each attendance.
 
* Mileage (if there is any) will be charged at 45p/mile.
 
* If the client cancels they will be charged £10.
 
 
 
The rate card for council clients is to be set up the same way, but with a charge of £25, and for council clients, they will be charged the full fee even if they do not attend.
 
 
 
 
 
[[File:A_accounts_10.png|border]]
 
 
 
 
 
You should now have two new rate cards on your system.
 
 
 
 
 
[[File:A_accounts_11.png|border]]
 
 
 
 
 
Now you need to link the cost centres and rate cards to one another in the relevant project.
 
 
 
==General Rates in Projects==
 
 
 
Click on the "General Rates in Projects" menu link.
 
 
 
 
 
[[File:A_accounts_12.png|border]]
 
 
 
 
 
You now need to select the project in question (Daycare);
 
 
 
 
 
[[File:A_accounts_13.png|border]]
 
 
 
 
 
Then allow the charge rates in the project, and link them to the relevant cost centres.
 
 
 
 
 
[[File:A_accounts_14.png|border]]
 
 
 
 
 
==Assign rates to activity==
 
 
 
Whenever there is work to be invoiced, you need to set a charge rate for that activity. In the case of Clubs and Clinics, this rate is set on the membership card - which shows all details of the client's membership of that particular club or clinic. It can be accessed by clicking on the "Club & Clinic Membership" link at the bottom of any Client Details screen, and then clicking on the card as shown;
 
 
 
 
 
[[File:A_accounts_15.png|border]]
 
 
 
 
 
This will take you to the following screen. This shows all the details of this client's membership of this club, and there is a space for charge rate.
 
 
 
 
 
[[File:A_accounts_16.png|border]]
 
 
 
 
 
Once the rate is set, click "Save Details".
 
 
 
==Carry out activity in Charitylog==
 
 
 
The activity can now be carried out in Charitylog in the usual way. In the case of Clubs & Clinics, it can be done using the Wizard or by following the steps of the "Create/confirm/complete" process. Details of running Clubs and Clinics can be found here:
 
 
 
==View Invoices==
 
 
 
==List Invoices==
 
 
 
==Print Invoices==
 
 
 
==General Pre-Invoice List==
 
 
 
==HP Pre-Invoice List==
 
 
 
==SW Pre=Invoice List==
 
 
 
==Export Invoices==
 
 
 
==Export Payroll/Invoice Data==
 
 
 
==HP Material Costs==
 
 
 
==HP Project Labour Costs==
 
 
 
==HP Standard & Project Nominal Codes==
 
 
 
==Rates==
 
 
 
==Rates in Projects==
 
  
==Cost Centres==
+
If you do not have a pre-set system for assigning accounts codes, the system will let you use '''People/Organisation IDs''' as your accounts codes, with a prefix if you want to apply one. This can be done in [[Operational Rules]]. Note that if you want to do this, the codes will not all be filled in automatically; you need to go to each client and re-save their record, and the "accounts code" field will auto-populate.
  
==Invoice Layouts==
+
==Invoicing for Clubs & Clinics==
  
==Invoicing Parameters==
+
See [[Invoicing for Clubs & Clinics]].
  
==Payment Methods==
+
==Invoicing for the Roster Module==
  
==VAT Codes==
+
See [[Invoicing for the Roster Module]].
  
==General Charge Rates==
+
==Accounting for Handyperson activity==
  
==General Rates in Projects==
+
See [[Invoicing for the Handyperson Module]]

Latest revision as of 17:46, 2 February 2024

Helpheader small.png

What is the Accounts Module?

If you're using the Handyperson Module, you will probably be using the simple accounting tools that it provides - namely, charging for materials and work done, automatically working this out to give a cash total on the job card, and producing reports about how much money has been spent/charged.

We soon found that some of our clients needed more accounting functionality. More and more organisations are having to account for exactly what they have done, and provide an invoice to (for example) the council, rather than just working under an SLA. Individual Budgets are also having an impact (where the client is given benefits/grants and has to purchase and manage their own care/services, rather than the care/services being provided to them with no money changing hands). The Accounts Module is the answer.

Using the Accounts Module you can:

  • Automatically generate invoices for club/clinic activity (when using the Clubs and Clinics module), support work (when using the Support Worker Module), and handyperson services (using the Handyperson module).
  • Create invoices to the client directly, or invoice a funder/organisation on their behalf.
  • Print invoices directly from the system.
  • Export invoices directly from the system to the industry-standard Sage Line 50 accounting package, with department and nominal codes automatically assigned.

Accounts module warning

It is important that invoices are not created by two different system users at the same time. This would lead to errors in invoice numbering. Therefore, you may see a warning when you try and access accounting features, to make sure that the invoicing process is not in use elsewhere. If you know you are the only person using invoicing at that time, you can ignore the warning and continue.

Setup of the Accounts module

Before starting to use the accounts module, there are a few things that need setting up.

Invoice Layouts

Click the "Invoice Layouts" menu item, in the "General Accounts Setup" submenu.


Clog invoice layouts.png


This will take you to a screen displaying the invoice layouts available. Currently the system ships with five standard layouts, but there is scope to add to these - please get in touch if you need a different layout.


A accounts 30.png


You do have some editing control, though - click the "Edit" button to edit a layout. Here the standard layout is shown.


Clog edit invoice layout.png


You can set standard text, and a block of text to print on a following page to each invoice (this is useful for involved terms and conditions, for example). You can also specify image files (an absolute Web path) to print on your invoices. This is a good way to get your standard letterhead or graphics on your invoices.

Invoicing Settings

Click the Invoicing Settings menu item, in the "Invoicing" submenu.


A accounts 32.png


This screen will let you edit;

  • Last used invoice numbers - very useful for starting your invoicing with the system where a previous system stopped, rather than having to begin from 0.
  • Which standard layout to use for each type of activity.
  • Number of days until payment is due.


Inv parameters.PNG

Payment Methods

Click the "Payment Methods" menu item, in the "General Accounts Setup" submenu.


PayMeth.PNG


Here you can set up custom payment methods, which can be used for particular customers (for example, if you have a few customers that pay cash, and the rest pay by cheque). This is only necessary if you want different text to be carried onto the invoice for a particular method - for example, you might want "Please only pay cash into our account at the bank directly. Please do not bring cash into our office" or similar for a cash payment method.

If you don't need different payment methods, you can ignore this.

Overview of the Accounts module

The accounts module is fairly separate to the rest of the system, which from the point of view of setup is a good thing, because end users don't usually have to worry about it. Usually, beside any activity which can be invoiced for, there will be a button which looks like a pile of coins. Clicking on this will let you see which charge rate is being used for the activity. In some cases there is a drop-down list of the available rates. There is a lot of setup to be done for the accounts module to work correctly, but once this is done, there is minimal ongoing work, apart from printing the invoices and exporting the data.

Occasionally you may see an error message like the following:


A accounts 21.png


Accounts is one area of the system where it is very important that there is only one person creating invoices at a time. Therefore the system is quite careful about letting more than one person use it, and will show this warning when it thinks there is a clash of users. If the warning relates to your own username, feel free to click "Click here" (as long as you aren't using invoice processing in several tabs at once, which is not advised). If the warning relates to another user, you should stop and contact that user to make sure that only one of you is using the invoicing section at once.

The accounts module is intended to be used to invoice for work once it has actually been carried out, but with some careful thought, it can also be used to invoice for work in advance. Working out the best way to do this can be tricky and so you should discuss this with your assigned system trainer, and with the support department.

The accounts module can currently be applied to Club & Clinic activity, Support Worker work, or Handyperson activity. Clubs & Clinics is part of the core system; Support Worker and Handyperson are two of the available add-on modules for the system. You should have good grasp of what these modules can do before setting up the accounts module to work with them. If you need to invoice for other activity, such as volunteer assignments, please give the support department a call. We plan to extend the accounts module at some point, and we depend on customer feedback to let us know what we need to develop.

This flow chart shows the complete process, which we will use as the basis for this chapter.


A accounts chart1.png


Example set of nominal/department codes

As you set up the accounts module, you will need to enter department and nominal codes, which are a way of categorising activity and associated money. We will use the following set of example codes, and refer back to them throughout the guide.

Department codes

Daycare (private clients): 10
Daycare (council clients): 20

Nominal codes

General/other: 1000
Fixed charges and administration costs: 5000
Travel time: 7000
Mileage: 6000
Client mileage: 8000

Assigning accounts codes

The first thing you will need to do as part of the setup of the Accounts module is to assign customer IDs to anybody who is going to receive an invoice. You may already have an internal system for accounts codes, or they may be provided for you by a funding body.

On the client details screen, there is a space for "Accounts code" on the Personal Details tab:

A accounts 1.png

For funders, there is a similar field on the "General Details" tab of the Funder Details screen.

A accounts 2.png

It is in a similar place on the Organisation Details screen.

Automatic accounts codes for people on your system

If you do not have a pre-set system for assigning accounts codes, the system will let you use People/Organisation IDs as your accounts codes, with a prefix if you want to apply one. This can be done in Operational Rules. Note that if you want to do this, the codes will not all be filled in automatically; you need to go to each client and re-save their record, and the "accounts code" field will auto-populate.

Invoicing for Clubs & Clinics

See Invoicing for Clubs & Clinics.

Invoicing for the Roster Module

See Invoicing for the Roster Module.

Accounting for Handyperson activity

See Invoicing for the Handyperson Module