Importing client data using Excel or CSV format
You can import manual data to a client anytime.
Key points when preparing your file for importing
Only administrators can import files.
The file type is CSV, txt or xlsx and has basic data such as account code, account name and balance (or debit/credit).
Make sure all the columns in your import have column headers.
Make sure there are no blank rows in the data and thousands are not separated with a comma
Ensure your dates are in the date format in Excel and your data is YTD.
Example
Date | Account number | Account name | Account type | Amount |
31/12/2017 | 1179 | AP Account | asset | -1500 |
31/12/2017 | 2204 | Accounts Payable (1) | liability | 35000 |
30/09/2017 | 2205 | Accounts Payable (VAT) | liability | 65000 |
31/12/2017 | 2000 | Accounts receivable | asset | 0 |
You can upload as much information as you want into client accounting, so it might be worth designing a firm-wide template to use for this.
When adding a new client, in the Sync section, select Excel or CSV in Where do you want to fetch the data from? question.
Select the columns you want to import and match the column headers with the appropriate columns in Client Accounting .
The following columns are essential to successfully add the data (but you can import as much information as you feel necessary).
Account code: the account code for that particular line item
Account name: the name associated with the ledger code (e.g. Issued capital)
Account type: the account type associated with the account. This will determine if the opening balance needs to be brought forward for the account or if it needs to be included in the retained earnings of the next financial year. The following account types should be used:
asset,
liability
expense
income
equity.
Credit/ debit value: you can either select the value (balance) or both the debit and the credit columns. Keep in mind that the sum of all the accounting values needs to equal zero.
Booking date and/or period: The booking date, allows you to associate bookings with a chosen period.
Other columns
If you don’t want to add a column, then choose ‘Ignore’, for example, in case of unnecessary information.
Choose ‘other value’ if you want to upload the data into the Silverfin program and you can then name the columns yourself. Checking the items will confirm the selection.
When you have configured everything correctly, click ‘Next’.
Check the data. This is to make sure that data is checked and complete before being uploaded.