Skip to main content

Creating a Sales Ledger

This article outlines how to create a sales ledger from the CRM.

Written by Heather

The CRM integrates with multiple accounting systems. The link between the CRM and the accounting system is the Sales Ledger, which is stored on the Company. This article will focus on creating a Sales Ledger from the CRM using the information stored on the Company. 

If you have already created the Sales Ledger within your accounting system, see Setting a Sales Ledger on a Company.

Prerequisites

Only users with CRM Admin privileges may have the ability to create Sales Ledger accounts. If you are not a CRM Admin, request the necessary permissions from your Admin or ask an Admin to create the account on your behalf.


Create a Sales Ledger

Step 1: Go to a Company or Quote

To create a Sales Ledger, click within the 'Sales Ledger' drop-down located on either the 'Details' page on a Company or on a Quote within the 'Target Sales Ledger' Field. Select the 'Create Sales Ledger' option from the drop-down.

Step 2: Add information

You will then be asked to fill out information about the new Sales Ledger. The CRM will try to use the information available on the Company, such as Telephone, Fax and Website to avoid the user having to re-enter this information. 

Based On: In order to create a new Sales Ledger you will need to choose an account to use as a template. You can either choose from your configured model accounts, or search for another Sales Ledger to use as a template.
​Sales ledger ID: Simply type in the Sales Ledger code that will be used within the CRM and your accounts system as a reference for your new Sales Ledger. E.g. SS001. Please note: this needs to be unique from any other Sales Ledger codes.
​Name: This would be the name of the Company that you're setting this new Sales Ledger for.
​Email: The email featured here will be the main Contact's email address which will appear against the Sales Ledger.
​Website: This should be the website address for the Company. Again, by default, this will be taken from the Company if previously entered already.
​Fax & Telephone: These Contact details will be taken from the Company if previously entered already. Please enter if they were not included on the Company.
​Warehouse: When this customer orders Products from your business, then the products will be taken from the Warehouse selected.
​VAT Registration Code: Here you can enter the customer's unique code which is issued when companies are registered to pay VAT.
​Currency: Choose the appropriate currency that this customer will purchase in from the drop-down.
​Tax Code: The tax codes displayed within the drop-down will be imported from your accounts system. You will need to choose the most suitable option.

Step 3: Edit the Address

Finally, you can edit the Sales Ledger address by clicking the 'Edit Address' button. It will automatically pull through the Company address, but you can edit this if required. Once happy with your changes, click 'Close'. 

Your new Sales Ledger will then be created and will be imported into your Accounting system once your imports have completed.


Frequently asked questions

Will past transactions move to a new Sales Ledger?

No, past transactions will remain on the original ledger. Only new transactions will post to the updated ledger.

What should I do if I can’t create a Sales Ledger account?

Check your permissions. If you are not a CRM Admin, you will need to request access or have an Admin create the account for you.

Did this answer your question?