Download - Module 2- Customers V7.0
-
8/6/2019 Module 2- Customers V7.0
1/27
1
Module 2: Customers
-
8/6/2019 Module 2- Customers V7.0
2/27
2
Contents
Create a Customer Record ......................................................................... 3
Enter a Sales Invoice................................................................................... 6
Reset a Sales Invoice ................................................................................ 11
Collect a Payment..................................................................................... 13
Allocating a Sales Receipt......................................................................... 13
Entering a part payment ........................................................................... 15
Entering an unallocated Sales Receipt...................................................... 15
Edit or Delete a Sales Receipt ................................................................... 17
Editing or Deleting a Sales Receipt with invoices allocated against it....... 19
Sales Receipts that have been Bank Reconciled ....................................... 19
Enter a Sales Credit Note.......................................................................... 20
Sending Statements .................................................................................. 25
How to send statements to your customers ............................................... 25
To send a statement to just one customer ................................................. 25
To send statements to all your customers ................................................. 26
Sales Analysis........................................................................................... 27
-
8/6/2019 Module 2- Customers V7.0
3/27
3
Create a Customer Record
Select the Sales menu tab and then press the Customer details button.
The first time you use this screen to enter a customer, the screen will be blank.
Click on the New Customer button to bring up a new blank record.
If you have several customers already, you may want to see if the customer youare about to enter has already been created. You can do this by searching on the
customer code.
NOTE: Only the customer code field is mandatory on this screen, the other fields can
all be left blank to be filled in later if needed.
-
8/6/2019 Module 2- Customers V7.0
4/27
4
Creating a new customer - step by step
Notes on completion of the New Customer screen:
Enter the company code*and the company name.
Enter the address and postcode.
If the company is VAT registered, it is important to choose the country from thedrop down list. The default is UK.
Enter the phone and fax number.
Enter thewebsite.
Enter the accounts contact details (the persons name you will be dealing with).
Enter their email address and how they should be addressed in correspondence
in the dear field.
If the customer is VAT registered, you should enter theirVAT number. The systemwill check that the VAT number is in a valid format for the country you have
elected. If you remove the VAT number, you will get a no VAT number error but
you can continue without putting a VAT number in.
If you want to set up a default VAT code for the customer, select it in theVAT code
override field.
If the customer pays immediately, click the cash account box.
If this customer has special terms, enter the number of days in the terms no of
days, and details of the special terms in the terms text field. Tick the EOM box toset the terms as the end of the month.
-
8/6/2019 Module 2- Customers V7.0
5/27
5
You can put any additional notes about the customer in the Notes field. This wont
be shown on an invoice.
If you want to put the customer on stop, select yes from the drop down menu.
If you have multi-currency module enabled, choose the default currency for this
customer.
If required, enter a credit limit for the customer.
To save the record, press the save button.
Next steps
To create a new customer, click on the New customer button.
-
8/6/2019 Module 2- Customers V7.0
6/27
6
Enter a Sales Invoice
Press the Sales tab and then click on the Invoicing button.
If you have come from the Customer details screen, the invoice record shown will
correspond to the last customer you looked at.
If the invoice record shown is not for the customer you want to work with, select
the desired customer.
Now click on the New invoice button.
The invoice number is automatically assigned by the system and appears in the
Our invoice number field when the record is saved. This ensures that every
invoice is uniquely identifiable.
Enter the Delivery date. If you put a full-stop [.] in this field and press tab, todays
date will be entered. Alternatively, click on the calendar icon to choose a date.
-
8/6/2019 Module 2- Customers V7.0
7/27
7
The Invoice date and Settle dateare completed by the system. The Invoice date is
the same as the delivery date. The Settle date is generated by the system by
adding the number of days in your terms for that customer (e.g. 30 days). Thesecan be overwritten if desired.
Complete any required optional fields:
Deliver toenables you to enter a delivery address or instructions. If left blank it
will automatically pull the address entered onto the customer details page.
The Notes fieldallows you to make any additional notes about the order.
Whatever you type here will NOT appear on the invoice. This field is only for your
records.
Their Refis a field to help the customer identify their order, e.g. a purchase ordernumber.
Currency code/ rate will only appear if you have the multi-currency module
enabled.
Press the New line button below.
For a simple line item, type the detail of the goods or services being invoiced into
the Detail box. Press the [+] button to open the editor. The editor acts like aword- processor.
Type the number of items sold in the Quantity field.
Enter the price per item in the Price field.
The software will calculate the Net value for you. If you only know the gross
-
8/6/2019 Module 2- Customers V7.0
8/27
8
amount, enter the gross amount and then press the G>N button.
If you are registered for VAT, the Tax code box will default to whatever you have
set it as in the customer details page. You can overwrite it if need be.
To select a different Tax code to the default one, simply select one from the dropdown menu. To do this, you must either begin typing the code into the box (e.g.
o1) or leave the field blank. TheVAT will automatically be calculated.
Select the desired Nominal code from the drop down menu. If you have selected a
default nominal code in the customer details screen, it will default to this. If the
required nominal code is not there, you can create a new one on the Nominal set-
up button under the Company tab.
Press Save to complete the line.
-
8/6/2019 Module 2- Customers V7.0
9/27
9
To add another line, press the New line button
When you have finished adding line items, check that all your figures are correct
before marking the invoice complete by clicking the Complete button.
To print the invoice, press the Print PDF button. This button appears after you
have completed the invoice. You can select a template from the drop down menu
to the left, as well as select the number of lines to show on each page of the
invoice. It will default to 10.
-
8/6/2019 Module 2- Customers V7.0
10/27
10
Alternatively, you can email the invoice directly from the system. To do so, select
the template and then press the Email button. The screen below will now appear.From here, you can choose who to send it to, enter the subject of the email, write
the email, and select a footer. Simply press Send to send the email.
It is not essential to create a copy for your records, as the invoice is held on the
system. You can access it and produce a print or electronic copy at any time.
-
8/6/2019 Module 2- Customers V7.0
11/27
11
Reset a Sales Invoice
This help document will show you how to reset a sales invoice on Liquid Accounts.
If you have pressed the Complete button on a sales invoice, the system will not
allow you to delete or edit any of the contents of this invoice. If you are loggedinto Liquid Accounts as an administrator, you can wind back the status of this
invoice so that it is no longer completed and hence can be deleted or edited.
Select the Sales tab then the Invoicing button.
Use the Search box to find the required customer, and then select the invoice to
be reset by clicking on the number.
The invoice needs to be reset if the invoice status says Ready for Printing or
Printed.
-
8/6/2019 Module 2- Customers V7.0
12/27
12
To reset the invoice press the Reset button.
Untick the Printed and Completed check boxes and then press Update. Once the
changes have been saved press the Go to invoice button and it will take you back
to the invoice.
The invoice status should now be Being created. You can now delete or edit any
of the lines by selecting the Delete or Select hyperlinks respectively.
-
8/6/2019 Module 2- Customers V7.0
13/27
13
Collect a Payment
Allocating a Sales Receipt
Select the Sales menu tab at the top of the screen and then choose the Money
Collectedmenu option.
Ensure you have the correct customer selected. If not, use the Search box at the
top of the screen to select the required customer.
Definition: Allocation
This screen shows Sales Invoices (SI) that you have entered onto the system. It
may also show Sales Receipts (SR) that you have entered. You can enter Sales
Receipts, when people pay you, or when you see the money going into your bank
account. The system needs you to Allocate or match SIs and SRs together, so that it
knows what Receipts are paying for which Invoices. By doing this, the Invoices
will then be cleared off this screen, keeping it all as clean and simple as possible.
-
8/6/2019 Module 2- Customers V7.0
14/27
14
Tick the Select boxes for the Sales Invoice(s) that you have received payment for.
You can select as many as you like; they will be added to the total amount.
The total selected amount is displayed in theAmount box below.
In theAmount received section below, select the Bankaccount and the Date of the
Sales Receipt that you are entering. Enter any relevant details in the Their refand
Our refboxes.
Press Save/ Allocate. This will generate a sales receipt and automatically allocate
it against the selected invoices.
If the amount selected was a full payment, the Sales invoice will be removed from
the list.
-
8/6/2019 Module 2- Customers V7.0
15/27
-
8/6/2019 Module 2- Customers V7.0
16/27
16
Press Save/ Allocate and it will appear as a Sales Receipt above.
To allocate the sales receipt to a sales invoice, tick the Select boxes next to the
corresponding invoice and receipt. You can select as many receipts and invoices
as required. TheAmount field below should equal zero. Press the Save/ Allocate
button below and they will allocate and disappear from the list.
-
8/6/2019 Module 2- Customers V7.0
17/27
17
Edit or Delete a Sales Receipt
This help document will show you how to edit or delete a sales receipt on LiquidAccounts.
Select the Sales menu tab at the top of the screen and then choose the Invoicing
menu option.
Ensure you have the correct customer selected. If not, use the search function at
the top of the screen to select the correct one. Find the sales receipt that you wish
to edit in the list. Click on the sales receipt number.
Depending on whether the receipt has had invoices allocated to it or not will thendepend how the next screen will look.
-
8/6/2019 Module 2- Customers V7.0
18/27
18
The example below shows a receipt with no invoices allocated against it and
therefore the receipt can be fully edited by pressing the Edit button, or deleted
by pressing the Delete button.
If you chose to edit it, you can now make any changes you need to. Press the Save
button to save the changes.
-
8/6/2019 Module 2- Customers V7.0
19/27
19
Editing or Deleting a Sales Receipt with invoices allocated
against it
If the sales receipt has had invoices allocated against it, they will be shown on the
right-hand side of the screen. You can still edit elements of the sales receipt such
as date and bank account by pressing the Edit button, making your changes and
then pressing the Save button. If you wish to edit any other aspect of the sales
receipt, or to delete it, you will firstly need to un-allocate these invoices from the
sales receipt. In order to un-allocate the invoices, press the Unmatch Invoices
button.
Once the Unmatch Invoices button has been pressed, the screen will update and it
should show no allocated invoices.
The receipt can now be edited or deleted.
Sales Receipts that have been Bank Reconciled
If a sales receipt has been bank reconciled, when you try and edit or delete it a
warning box will appear. You will need to go out of this screen and into Check my
statements and un-reconcile the transaction before the system will allow you to
edit or delete it.
-
8/6/2019 Module 2- Customers V7.0
20/27
20
Enter a Sales Credit Note
This help document will show you how to enter a full or partial credit note. A
credit note is used when full or partial credit has been given to the customer.
Please note; a credit note has to be allocated against the original invoice.
Full credit note
Press theSalestab and then theInvoicingbutton.
Select the invoice you wish to create a credit note for. Click the number to select
it.
Press theCredit notebutton.
-
8/6/2019 Module 2- Customers V7.0
21/27
21
In theNotesfield, CREDIT AGAINST INVOICE 40 (or whatever number your
invoice is) will appear automatically, although you can override this. If you make
any further changes to the header, press theUpdate header onlybutton to savethese changes. If you need to edit the line details, press Selectnext to the chosen
line.
PressCompleteto finalise the credit note. It will now appear on the invoice list as
a credit.
To allocate the credit note with the invoice, go toMoney collected.
-
8/6/2019 Module 2- Customers V7.0
22/27
22
Tick theSelectboxes next to the sales invoice and credit note you wish to
allocate. TheAmountshould equal zero [0] for a full credit note. Enter the details
and press Save/ allocate. They will now be allocated.
Partial credit note
There are two ways to create a partial credit note. You can follow the method
demonstrated for a full credit note; simply deleting the lines that you dont want to
be included in it. Alternatively, as the example below demonstrates, you can
create a new invoice with a negative [ - ] amount in the line details.
Press theSalestab and then theInvoicingbutton.
Press theNew invoicebutton.
-
8/6/2019 Module 2- Customers V7.0
23/27
23
Enter the header details and then pressNew line. You may wish to record in the
Notes box that it is credit towards a particular invoice.
Enter the line details. Ensure you put a negative amount [ - ] in theQtyfield and
have it attributed to the same Nominalcode as the original invoice. PressSave.
PressNew lineif you need to add any additional lines to the credit note.
To allocate the invoice with the credit note, go toMoney collected.
-
8/6/2019 Module 2- Customers V7.0
24/27
24
Tick the boxes in theSelectcolumn next to the relevant invoices. In theTo
allocatecolumn, edit the figure of the original invoice to match that of the creditnote.
TheAmountshould equal zero [0] below. Enter the details and press theSave/
Allocate buttonto allocate. Once the credit note has been allocated, only the
amount left to pay will be shown on the list.
-
8/6/2019 Module 2- Customers V7.0
25/27
25
Sending Statements
How to send statements to your customers
You can send statements to your customers showing their outstanding invoices.
Most people do a statement run once a month. You can send statements to all your
customers, to a batch of customers, or to a single customer.
Note that only unallocated items (which have not been allocated a payment yet)
will appear on a statement, including payments in and payments out, for example
credit notes and refunds.
To send a statement to just one customer
Press the Salestab and then the Send statements button.
To print a statement for just one customer, the customer code in theAccount from
andAccount to fields should be the same. Select the Template you wish to use and
the Invoice outstanding prior to date. It will default to todays date.
PressApply. The statement will then be brought up, ready to print.
-
8/6/2019 Module 2- Customers V7.0
26/27
26
To send statements to all your customers
Press the Salesmenu tab and then the Send statements button.
Accept the defaults in theAccount from andAccount to fields as shown below.
Amend the Template and Invoice outstanding prior to date if required.
Press theApply button. The statements are all produced together as one
document, ready for printing.
-
8/6/2019 Module 2- Customers V7.0
27/27
Sales Analysis
Sales analysis allows you to analyse the sales of each individual customer in a
chosen time period.
Press the Results tab and then the Sales analysis button.
Search for the Customer. The date range will automatically select the current
month. To override it, select a new Date from and to using the drop down
calendar.
This will bring up a list of all the Sales Invoices for the chosen company in theselected time period.