User Guide - Loading from Spreadsheet

Guidance

It is important that you understand the Accounts Structure that Parish Council Accounts provides, and how you can represent your councils requirements within it. On installation a demonstration council is provided. Use this to familiarise yourself with the features of the application.

  1. Create the Council and the Cashbooks
  2. Do a backup, and give it a memorable prefix.
  3. Create the Accounts structure. This can be done by loading a CSV file (see below).
  4. Create the Suppliers. This can be done by loading a CSV file (see below).
  5. Load the Cashbooks Entries. The important thing is that the names, in the cashbook CSVs, are the same as those loaded in 3 and 4 above.
The problem tends to be that the columns people use in spreadsheets are not usable as account names, but can be used as the description. So a certain amount of reformatting is required.

Loading Accounts

This is accessed from the menu; Setup -> Load Accounts...

The format of the Accounts CSV file is as follows: 

Name,Description,Parent,Type
Name, Description, and Parent must be specified. Type I for Income, E for Expenditure, or blank. If blank a Balance Account will be created.

Loading Suppliers

This is accessed from the menu; Setup -> Load Suppliers...

The format of the Suppliers CSV file is as follows: 

Name,VATNo

This website stores cookies on your computer that are used to manage the order in which you see the pages. To find out more about the cookies we use, see our Privacy Policy.