Adding client data using Excel or CSV

When you add data from CSV or Excel, they don't sync automatically and all changes must be done manually.

Uploading the Excel or CSV file

You can upload the file

• When linking a client, select Upload file.
  

  

• after changing a file’s sync from the current automatic synchronisation to manual upload. in the Client overview, click Actions and choose Replace bookkeeping data.
  

  

Importing the data

1. Select the columns you want to import and match the column headers with the appropriate columns in Client Accounting.
   

   

2. The following columns are essential to add the data successfully (but you can import as much information as you need).

   1. Account code: the account code for that particular line item

   2. Account name: the name associated with the ledger code (e.g. Issued capital)

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

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

   5. Booking date and/or period: The booking date allows you to associate bookings with a chosen period.

   6. Other columns

      • If you don’t want to add a column, then choose Ignore.

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

3. Check the data. This is to make sure that the data is checked and complete before being uploaded.
   

Sample template