Billing Guide

See also our user guide on completing the month end billing run: 11. How to complete the month end billing run on DataTill

  1. Billing Setup
  2. View Imported SageOne Data
  3. Product Pricing
  4. Finance Guide
  5. Finance in the Customer Menu
  6. Debit-Run Batches
  7. Customer Portal

1. Billing Setup

In order to use the billing functions the billing needs to be setup. This involves setting up the Billing setup, creating billing groups and setting up the Accounting integration. Currently, only Sage one integration is supported.

1.1 Setup steps

  1. Go to Billing -> Billing Setup
  2. Billing settings include:
    1. Currency
    2. Financial year end
    3. Month end cut-off
    4. VAT
  3. Don’t forget to click on the update button.

billing-basic-setting-1

billing-basic-settings-2

1.2 Billing Groups

    1. Go to Billing -> Billing Setup -> Billing Groups
    2. Click on “+ Add Group”
    3. Insert a Group title and a group description
    4. Click on “Add Group”
    5. At least one billing group needs to be created. Customers cannot be created without a billing group.
    6. Billing groups are used to group all the customers of the same billing date, e.g. customers who want a debit order on the 1st of each month will be put in one group, so all the customers who want to be billed on a specific day will be grouped accordingly.
    7. The Billing Group will be synced to sage.

billing-add-group
1.3 Invoice Setup

      1. Go to Billing -> Billing Setup -> Inv & Credit Note Setup
      2. Fill out the General Settings.
      3. Add Bank Account Details
      4. Setup how you want your invoices.
      5. Add in Credit Note Settings.
      6. Statement Settings.
      7. Click update at the bottom of the page after your setup and changes has been done.

inv-general-settings

inv-bank-account-details

inv-settings

credit-note-settings

statement-settings1.4 Accounting Integration Setup

      1. First create a dedicated API user in sage with full administrator rights, for datatill.
      2. Then on DataTill go to Setup -> System Settings -> Accounting Integrations.
      3. Fill in these details in this form. A minimum transaction date is critical. Note for products you cannot have the same in datatill as in SageOne, so just make some slight variance of the names in either Sage or in DataTill.
      4. This is Absolutely Critical. If the API test is successful then you can proceed with syncing.
      5. Fill in all the necessary information, Test the API.
      6. If the API test is successful then update the settings. sync: item categories, analysis codes, account list and Tax rates. Make sure you click on all the sync buttons at the bottom.
      7. Please avoid generating test data that you would like to delete, If you would like to delete information. please contact us and we will guide you through the correct process.
      8. If you do this incorrectly you can run into major problems.
      9. The 3 analysis codes are the analysis codes that can be used in Invoices. eg. the invoice can be linked to a Highsite or payment method, ect. .

accounting-integration

2. View Imported SageOne Data

      1. Go to Billing -> SageOne Data.
      2. Here yo will see a list of account, bank accounts, item categories, items, customers and GL transactions.
      3. These are all details that are synced with sage, They can only be edited in sage, but are used in DataTill.

list-of-accounts

 

sageone-bank-accounts

sageone-item-categories

list-of-items

sageone-customers

list-gl-transactions

Sage One Sync queue

      1. Go to Billing -> SageOne Data -> Sync Queue.
      2. Any records that do not sync successfully will be listed here.
      3. You can try and sync items individually by clicking on the little refresh button on each row.
      4. Check the sync queue regularly to see if there are any syncing errors.

sageone-sync-queue3. Product Pricing

3.1 Product Types

      1. Go to Billing -> Products -> Product Types.
      2. These are basically product groups.
      3. Each type is dependent on a SageOne category, Therefore the product type needs to first be created in SageOne and then created here.

product-types3.2 Non-Data Products

      1. Go to Billing -> Products -> Non Data Products.
      2. Click on add-product-button to create a product.
      3. Add you desired product. There can be many products for each product type.
      4. Each Product is linked to a Sales Account, these Sales accounts come from Sage, so if you need a sales account not listed then it needs to be created in Sage.
      5. Products cannot be disabled for selection.
      6. Make sure to add in a product cost.

add-non-data-product

3.3. Data Products

These are just your Radius Data Packages.

      1. They can be added by either going to Radius -> Data Packages or Billing -> Products -> Data Products.
      2. Click on add-data-package-button to add a data packages
      3. See the Radius Guides on how data packages work.

add-data-package

3.4 Data Pricing Matrix

Please refer to the Radius Guide for a better explanation of this.

This page is part of Radius. The data pricing matrix is an easy way to create and manage related Radius data products. Each Pricing Cell represents a Radius Data Package. Each row The Unshaped button just add a ‘U’or a ‘S’ to end of the Product code for the data packages. You can view the various product code’s by hovering your mouse over the cells.

4. Finance

4.1 Invoices

invoices-page

In the screenshot, you can see the invoices page. It gives you a list of all the invoices that have been created. To create an invoice, click on the “Create Invoice” button. While the invoice is still in draft status, you will be able to “edit” the invoice details as well as “Remove Invoices“.

Once an invoice has been created, it has to be generated. To do this click on generate-invoice-button . Once generated, the invoice will be synced with Sage one and DataTill will generate a .pdf version and email it to the client. Once the invoice has been generated, you will not be able to edit it again which is why you need to be sure that the invoice is 100% correct before pressing the generate button.

To send the invoice to the client, you can:
– Download the invoice by clicking on download-invoice and add it to your ticket.
– Click on email-invoice to send it to the client or an alternative email address.

4.1.1 Creating a New Invoice:

The important thing to remember when creating invoices is to add the analysis codes. You can add these by scrolling all the way right on the invoice pop-up screen. The analysis codes are usually as follows: High site, Jobs and Projects. You can, however, change the analysis codes according to your needs in the Accounting integration settings. The analysis codes need to be set up in Sage One first though and will then be imported from Sage One to DataTill.

create-invoice

      1. Start by going to Billing -> Invoices.
      2. Click create-invoice-button to bring up the create invoice menu.
      3. Select the Customer that is being invoiced.
      4. Select the Payment Method.
      5. Make sure the Invoice Date and the Due Date is correct.
      6. Add a Customer Reference if necessary (this could be a ticket number in most cases).
      7. Add the Product Type on the first line.
      8. Then add the Product on the same line.
      9. Double check if the Prices are correct.
      10. You can bill the same product more than once by increasing the Qty from 1 to how many you need.
      11. Click add-another-line-button to add another Product line.
      12. You can select a Catagory if necessary.
      13. You can type an Invoice Message if necessary.

*If the Select Customer menu does not work properly then try using Google Chrome. Make sure that there is a minimum transaction date set in the accounting integration settings. For the customer reference, try using the ticket number if a ticket exists.

4.1.2 Recurring Invoices

Recurring invoices are invoices that are repeatedly created at a set date and for a set period. DataTill will only generate recurring invoices for clients who have a constant month to month service with you. The product for which you would like to invoice must also be listed in datatill. All the Recurring Invoices will auto generated at the specified date you choose for your billing run. Please see the screenshot below to see what fields a recurring entry has. Recurring invoices can be used for the following examples.

      • Monthly capped or uncapped packages.
      • Monthly domain renewals.
      • etc.

add-recurring-billing-entry

      1. Go to Billing -> Recurring Billing -> Recurring Billing Entries.
      2. Click add-recurring-button to add a recurring entry.
      3. Select the Customer for which the recurring billing is.
      4. Select the Product Type.
      5. Select the Product.
      6. Select a Category if necessary.
      7. Type in a Description of the recurring billing if necessary.
      8. Set a Start Date for the recurring billing.
      9. Set the Interval for the recurring billing (Weekly, Monthly, Bi Monthly, Quarterly, Bi Yearly, Yearly).
      10. Set the End Date for the recurring billing.
      11. Set the Recurring Ammount.
      12. You can add a Discount if necessary.
      13. Enable or Disable the recurring billing by clicking on the on/off switch if in use or not.
      14. Then once all this has been done click add-recurring-billing-button-entry to add the recurring entry.

4.2 Credit Notes

Credit notes work similar to invoices in DataTill, so they also need to be generated. To generate a credit invoice you need the “modify accounting adjustments permissions”. Once generated the credit note will be pushed through to Sage and the customer will be sent the credit note.

add-credit-note

      1. Go to Billing -> Credit Notes.
      2. Click on create-credit-note-button to create a Credit Note.
      3. Select the Customer for which this credit note is for.
      4. Select the Original Invoice that needs to be credited.
      5. Set the Credit Note Date.
      6. If there is no original invoice then you can manually add the products in the Product Line by adding the Product Type, Product, Descpription, Qty, and Incl Price.

4.3 Adjustments

list-adjustments

Adjustments are used to load balance brought forward etc.add-adjustment

      1. Go to Billing -> Adjustments.
      2. Click on create-adjustment-button to create a Adjustment.
      3. Select the Customer that requires the adjustment.
      4. Add a Customer Reference if necessary.
      5. Add a Discription for the adjustment.
      6. Add Comments if necessary.
      7. Select Categories that are related to the adjustment.
      8. Set Analysis Codes if necessary.
      9. Set the Adjustment Date.
      10. Select the Affected Account (SageOne Account).
      11. Select the Vat Type if not using the default vat rate.
      12. Type in the Total of the adjustment.

4.4 Write-Offs

list-write-offsadd-write-off

      1. Go to Billing -> Write Offs.
      2. Click create-write-off-button to add a write off.
      3. Select the Customer that needs the write off.
      4. Add in a Customer Reference.
      5. Add in a Description for the write off.
      6. Add in a Category if necessary.
      7. Set the Write Off Date.
      8. Set the Total of the write off.
      9. Click create-write-off-button to create the write off.

4.5 All Documents

Go to Billing -> All Documents.

This is a list of all the finance documents in DataTill. ie Invoices, CreditNotes, Adjustments and Write Offs.

 

list-all-documents

4.6 Age Analysis

customer-age-analysis

5. Finance in the customer menu

These are the finance forms found in the customer menu. Go to customers->Total Usage List->Edit and the forms will be at the bottom left of the page. The Finance info in the edit customer screen.

Go to the customer menu. (Go to Customers -> Edit Customers and search the customer name or code)

5.1 Billing Details

each customer has a default highsite. this will be the default highsite selected for invoices.

billing-details-customer
5.2 Age Analysis

All the invoices pertaining to the customer can be viewed here.

 

age-analysis-customer

6. Debit-Run Batches

Generate Debit Batches

generate-debit-batches

      1. Go to Billing -> Debit Run Batches -> Generate Debit Batches.
      2. Select the Debit Date month and year.
      3. Add in a Batch Discription.
      4. Set the Invoices From an Invoices Till date.
      5. Click generate-debit-batch-button to generate the batch.
      6. Click on the blue Batch Breakdown button to download the debit batch in .csv format.
      7. Not that you can click regen-debit-batch to re-generate the debit batch if necessary.

7. Customer Portal

Here is a snapshot of what billing information the customer can see in the customer portal. The customer must log into the portal and click on the billing tab.

billing-customer-portal

 

See also our user guide on completing the month end billing run: 11. How to complete the month end billing run on DataTill