The Data settings allow you to set up the following.
Imports
The import data feature allows you to import various kinds of data such as contacts, budget, invoices etc in CSV format. You need to use one of the templates provided. The CSV template contains various columns that you are required to enter in the correct format. You must enter the mandatory columns before importing. The links below gives the steps to import data. Click the required link.
- Contacts - Customer/Supplier/Prospects/Business & Personal Contacts
- Product List
- Detailed Customer Invoices and Credit Notes
- Customer and Non-Customer Receipts
- Summary Supplier Invoices and Credit Notes
- Journals
- Monthly Budget Import
- Stock Adjustments
- Summary Customer Invoices and Credit Notes
- Detailed Supplier Invoices and Credit Notes
- Supplier and Non Supplier Payments
- Single Line Journals
- Yearly Budget Import
Accessing the Import Data Section
1. Login
2. Click Settings
3. The Settings page appears
4. Under the DATA heading, click Imports.
5. The Data Import page appears. Now select the appropriate data import option.
Note: All CSV Imports will be Queued. The Alerts will show once the import is complete. You can monitor the queued imports from CRM> Activities.
Contacts - Customer/Supplier/Prospects/Business & Personal Contacts
1. Select Contacts - Customer/Supplier/Prospects/Business & Personal Contacts.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the contacts' details
OR
- Download the template by clicking Template; enter the contact details in the template and then upload the template.
| In the CSV file you need to import, the mandatory fields are Code, Contact Type, Forename and Surname. |
4. To import, click Import.
5. The contact data start being imported, once it is next in the queue. You may verify by going to the contact type page.
Product List
1. Access the data import page and click Product List.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the product list details
OR
- Download the template by clicking Template; enter the product details in the template and then upload the template.
| In the CSV file, you need to import, the mandatory fields are Code, Description, SalesPrice, SalesVATCODE, SalesNominalCode, PurchasePrice, and Purchase VATCODE PurchaseNominalCode ProductCategory. |
4. To import, click Import.
5. The product list will start being imported, once it is next in the queue.
Detailed Customer Invoices and Credit Notes
1. Access the data import page and click Detailed Customer Invoices and Credit Notes.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the invoice and credit note details
OR
- Download the template by clicking Template; enter the invoice and credit note details in the template and then upload the template.
| In the CSV file you need to import, the mandatory fields are TransactionType, InvoiceNumber, TransDate, PONumber, Productcode, ContactCode. |
4. To import, click Import.
5. The detailed customer invoices and credit notes details will start being imported, once it is next in the queue.
Customer and Non Customer Receipts
1. Access the data import page and click Customer and Non Customer Receipts.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the receipt details
OR
- Download the template by clicking Template; enter the receipt details in the template and then upload the template.
| In the CSV file you need to import, the mandatory fields are ReceiptNumber, TransDate, Payer, ContactCode. |
4. To import, click Import.
5. The receipt details will start being imported, once it is next in the queue.
NOTE: The VAT ID or VAT Code field has now become mandatory going forward.
A validation message is added for the same.
Summary Supplier Invoices and Credit Notes
1. Access the data import page and click Summary Supplier Invoices and Credit Notes.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the receipt details
OR
- Download the template by clicking Template; enter the invoice and credit note details in the template and then upload the template.
| In the CSV file you need to import, the mandatory fields are TransactionType, InvoiceNumber, TransDate, ClientCode, VATCode. |
4. To import, click Import.
5. The invoice and credit notes' details will start being imported, once it is next in the queue.
Journals
To import Journals, complete the following steps.
1. On the Data Import page, tick Journals and click Next.
2. The Data Import > Journals page appears. If you have already downloaded the template, enter the details as per the table below. Else, click Template to download the template and enter the details. The template name is JournalFormat.csv.
| FIELD | DESCRIPTION |
|---|---|
| Date* | Journal date. |
| Ref | Unique journal reference number. |
| Type* | Enter Journal. |
| Note | Supporting notes. |
| Code* | Enter nominal codes for both debit and credit entries. |
| Item Line | Enter appropriate value. |
| Debit* | Enter debit amount. |
| Credit* | Enter credit amount. |
| * indicates mandatory inputs. |
3. On the Data Import > Journals page, click Choose File and select the template from your local disk.
4. Click Import.
5. The journal list will start being imported, once it is next in the queue.
Monthly Budget Import
1. Access the data import page and click Monthly Budget Import.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the budget data
OR
- Download the template by clicking Template; enter the budget data in the template and then upload the template.
- Select the period
- Select the divisions and subdivisions, if applicable, to allocate the budget to.
FIELD DESCRIPTION Current Period The details uploaded would be for the current financial year. Future Period The details uploaded would be for the upcoming financial year.
|
In the CSV file you need to import, the mandatory fields are Code and at least one period . Selecting a Period ( Current or Future) is mandatory. |
4. To import, click Import.
5. The monthly budget import details will start being imported, once it is next in the queue.
Stock Adjustments
1. Access the data import page and click Stock Adjustments.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the stock adjustments data
OR
- Download the template by clicking Template; enter the stock adjustments data in the template and then upload the template.
| In the CSV file you need to import, the mandatory fields are AdjustmentDate, ProductCode, AdjustmentType, Quantity . |
4. To import, click Import.
5. The stock adjustment details will start being imported, once it is next in the queue.
Summary Customer Invoices and Credit Notes
1. Access the data import page and click Summary Customer Invoices and Credit Notes.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the customer invoices and credit notes data
OR
- Download the template by clicking Template; enter the customer invoices and credit notes data in the template and then upload the template.
| In the CSV file you need to import, the mandatory fields are TransactionType InvoiceNumber TransDate ClientCode VATCode . |
4. To import, click Import.
5. The customer invoice and credit notes' details will start being imported, once it is next in the queue.
Detailed Supplier Invoices and Credit Notes
1. Access the data import page and click Detailed Supplier Invoices and Credit Notes.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the detailed supplier invoices and credit notes data
OR
- Download the template by clicking Template; enter the detailed supplier invoices and credit notes data in the template and then upload the template.
4. To import, click Import.
5. The detailed supplier invoice and credit notes' details will start being imported, once it is next in the queue.
Supplier and Non Supplier Payments
1. Access the data import page and click Supplier and Non Supplier Payments.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the Supplier and Non Supplier Payments data.
OR
- Download the template by clicking Template; enter the Supplier and Non Supplier Payments data in the template and then upload the template.
4. To import, click Import.
5. The supplier and non-supplier payment details will start being imported, once it is next in the queue.
NOTE: The VAT ID or VAT Code field has now become mandatory going forward.
A validation message is added for the same.
Single Line Journals
To import the Single Line Journals, complete the following steps.
1. Access the data import page and click Single Line Journals.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the Single Line Journals data.
OR
- Download the template by clicking Template; enter the Single Line Journals data in the template and then upload the template.
4. To import, click Import.
5. The single-line journal list will starts being imported, once it is next in the queue.
Yearly Budget Import
When you import the yearly budgetary figures, you can allocate annual budget to multiple divisions and subdivisions at one go. You can enter multiple divisions and subdivisions in the import template.
1. Access the data import page and click Yearly Budget Import.
2. On the Data Import page, click Next.
3. The Data Import page appears. You can do either of the following actions:
- Upload the template comprising the Yearly Budget data.
OR
- Download the template by clicking Template; enter the Yearly Budget data in the template and then upload the template. Note that you can enter multiple nominal codes and allocate budgetary figures to multiple divisions and subdivisions in the template.
- Select the period.
-
FIELD DESCRIPTION Current Period The details uploaded would be for the current financial year. Future Period The details uploaded would be for the upcoming financial year.
|
In the CSV file you need to import, the mandatory fields are Code and YTD . Selecting a Period ( Current or Future) is mandatory. |
4. To import, click Import.
5. The yearly budget details will start being imported, once it is next in the queue.
You can download the template and enter multiple budgetary figures for multiple divisions and subdivisions.
Exports
You can export all contacts, activities, opportunities, and, transactions from or for your business using the Data Export option by completing the steps:
1. Click Settings.
2. The Settings page appears.
3. Under the DATA heading, click Exports.
4. Click OK on the pop-up that appears.
5. The data is exported in Excel format.
Year End
Use the year-end to close the current accounting period and move to the next. To complete the year-end process, complete the steps.
1. Click Settings.
2. The Settings page appears.
3. Under the DATA heading, click Year End.
4. The Year End window appears. Read the messages carefully. Note that the process is irreversible and you should run it only when you are sure you have no changes to make in the current financial year. If you are happy with the outcome, tick I acknowledge the above information and understand this operation cannot be reversed.
5. Enter the RUN YEAR END, as shown and optionally, tick Copy this year's Budget figures to next year to move the current financial year budget to the next.
6. Click OK.
7. The Confirmation Message window appears. To proceed, click OK.
8. The Information Message window confirms the year-end completion.
Nominal Only Recalculation
The new Nominal only Recalculation feature that has been introduced allows you to re-calculate the current year nominal balances only. It however does not take into consideration the comparative years' or the customer and supplier ledgers. To re-calculate the current year's nominal balances, complete the steps.
1. Click Settings.
2. The Settings page appears.
3. Under the DATA heading, click Nominal Only Recalculation.
4. A pop- up message is displayed that states; " This Re-calculation routine will recalculate the current year nominal balances ONLY. It will NOT recalculate the comparative year or the customers and suppliers ledgers". Click OK to continue.
5. Once the calculation is completed, a validation message is shown.
6. If there are no nominal validation for the selected business, a message is shown.