Sage 50 Integration - General Information

Introduction

This user guide explains how to integrate Joblogic (JL) with Sage 50 in order to streamline your accounting and field service operations. This integration enables users to synchronise invoices, financial codes, and customer data seamlessly, reducing manual effort and enhancing financial accuracy.

Benefits of the Integration

• Seamless Invoice Transfers: Automatically push invoices from Joblogic to Sage 50, ensuring up-to-date financial records.

• Consistent Data Management: Keep customer and supplier information synchronised across both systems to prevent discrepancies.

• Reduced Manual Effort: Minimise data entry and lower the risk of human error.

• Real-Time Financial Insights: Gain instant access to accurate financial data for better decision-making.

• Enhanced Cash Flow Tracking: Easily monitor payments, expenses, and outstanding invoices.

Prerequisites

Before you begin, ensure the following:

1. You have an active JL account.

2. You have an active Sage 50 account. See our guide here on activating/installing Sage 50.

3. You have administrative access to both platforms to authorise the integration.

4. Make sure that your Sage 50 account has the necessary permissions for API (application programming interface) access.

5. All customers, suppliers, and invoices are up to date in both systems to avoid data mismatches.

Key Features and Functionality (An Overview)

Invoice and Payment Syncing

• Once an invoice/payment is approved within Joblogic, it can be pushed to Sage 50 with a single click.

• Ensure that tax codes and invoice details within your JL match your Sage 50 standards and settings.

Customer Data

• Automatically sync customer records, eliminating the need for duplicate entry.

• Updates in one platform are reflected in the other.

Financial Reporting

• Leverage Sage 50's reporting capabilities to generate profit-and-loss statements, balance sheets, and tax reports using synced data from Joblogic.

See the ‘What can be synced (in more detail)’ section of this guide for a fully detailed account of this.

The Integration Process

1. Enable Sage 50 Integration within Joblogic

Log in to your Joblogic account.

Navigate to Settings > Account Integration.

Locate the ‘Sage 50 Integration’ option and click ‘Connect to Sage 50’.

A pop-up will appear requesting your Sage 50 login credentials.

2. Authorise Joblogic within Sage 50

Enter your Sage 50 credentials and log in to your Sage 50 account.

Within Sage 50, authorise JL to access your Sage 50 data by following the on-screen prompts.

Grant permissions for the following:

a. Customer data

b. Invoice management

c. Tax configurations

Once authorisation is completed, Joblogic will confirm the integration.

3. Sync Data Between Joblogic and Sage 50

Navigate back to JL and access the Sage 50 Sync area under ‘Account integration’.

Select the data that you wish to sync:

Invoices/payments – sync from Joblogic to Sage 50

Customers: Sync between Joblogic and Sage 50 in both directions. However, a customer will only sync from Joblogic to Sage 50 if they have an approved invoice that is not yet in Sage 50.

Tax and nominal codes – transfer existing financial code settings within your Sage 50 for use against invoices within your Joblogic.

Click ‘Sync Now’ to initiate the process.

Note: on your first sync it would be best to only sync customers and/or tax and nominal codes to allow for set of these from one system to another. See the ‘What can be synced (in more detail)’ section of this guide for a fully detailed account of this.

4. Check the Sync Between Joblogic and Sage 50

Double-check that the tax and nominal codes have been transferred correctly within the settings area of your Joblogic.

Double-check that the customers within each system have transferred correctly.

Double-check that the invoices within Sage 50 have transferred correctly.

5. Configure Automatic Sync (Optional)

Navigate back to JL and access the Sage 50 Sync area under ‘Account integration’.

Enable the Automatic Sync option to schedule data transfers at specific intervals (e.g., daily, weekly, monthly).

Review and confirm your sync schedule.

6. Test the Integration

Before going live:

• Create a test invoice in Joblogic.

• Check if the invoice appears correctly in Sage 50 under the designated accounts/customer.

• Verify customer details, tax codes, and payment records.

7. Monitor and Maintain

Regularly review the sync logs in Joblogic to ensure there are no errors.

If any issues occur, Joblogic will display error messages. Resolve these by checking the customer data, tax codes, or payment settings.

Best Practices

• Perform a manual sync at the end of the day to ensure all data is updated.

• Regularly review your integration settings to ensure that synced data is accurate.

• Enable notifications in Joblogic to get alerts about sync errors or integration updates.

• Regular Data Audits: Periodically check for duplicates and mismatched data between Joblogic and Sage 50.

• Consistent Tax Codes: Always ensure tax codes are aligned across both systems.

• Backup Data: Maintain regular backups of financial data to prevent loss during sync errors.

• Team Training: Train your team to understand the integration workflow and troubleshoot minor issues.

Troubleshooting

Sync Errors

• If a sync fails, check the error message displayed within Joblogic’s ‘Sync History’ under settings. Common issues include:

• Missing/incorrect tax codes: Ensure all tax settings are correctly set against invoices.

• Duplicate customer records: Merge duplicate customers in Sage 50 or Joblogic before retrying the sync.

Authorisation Issues

• If the integration is not authorised within Sage 50, restart the connection process and reauthorise JL.

Support

For assistance, contact Joblogic Support at support@joblogic.com or Sage Support here

FAQs

• Can I sync historical data?

Yes, historical invoices and customer data can be synced during the initial setup process.

• Does this integration work with other versions of Sage?

No, this integration is designed for Sage 50 only.

• How often should I sync data?

Automatic syncing is recommended to keep records up to date, but it can also be performed manually at the end of the month, weekly, or daily, depending on your preferences.

Further General Information

What can be synced (in more detail)

The Sage 50 integration has the ability to sync customers, tax & nominal codes, and invoices, credit notes & payments. However, it is important to bear in mind which way these items are able to sync between Joblogic and the accounts package.

Customers

These items can sync both ways, meaning that customers in your Sage 50 account will sync to your Joblogic, and customers in your Joblogic account will sync to Sage 50.

However, customers will only sync from Joblogic to Sage 50 if an approved invoice for that customer exists in Joblogic. Any already existing customers in Sage 50 will sync across to Joblogic, providing that the customer has not been marked as inactive within the Sage 50 package.

It is important to ensure that the details for corresponding customers match up correctly in each system in order to prevent duplicates of the customer being created.

The name, email address, account number, address, telephone, and contact fields on the customer details page in Joblogic need to match the contact information page of the customer account in Sage 50 (contact name, email, account number, postal address, phone, primary person).

This Sage 50 to Joblogic function tends to be used if you are new to Joblogic and already have a Sage 50 account with customers logged. It acts as a useful tool for logging your existing customers automatically in Joblogic.

Tax and Nominal Codes

These will only sync from Sage 50 to Joblogic. This means that all of the codes set up in your Sage 50 package will be created within your Joblogic settings library in order to allow them to be used and allocated within Joblogic.

Invoices, Credit Notes, and Payments

This only refers to sales invoices (purchase/supplier invoices cannot be transferred via the live sync), and these only sync from Joblogic to Sage 50.

The Importance of Tax and Nominal Codes and Ensuring They Are Correct

Accounts packages use tax and nominal codes to define and categorise different types of financial data, and every accounts package typically has its own set of codes.

If items such as invoices, credit notes, and payments are labelled within Joblogic with tax and nominal codes that do not correspond with your accounts package, they will likely be rejected and fail to pass over to Sage 50 during a sync.

It is therefore important to ensure that the correct tax and nominal codes, in accordance with those set up in your Sage 50 account, are assigned to any invoices, credit notes, and payments to allow them to transfer successfully from Joblogic to the accounts package.

The easiest way to ensure this is achieved is to conduct a tax & nominal codes sync before assigning any codes to invoices, credit notes, and payments in Joblogic. This will ensure that those codes which correspond with your Sage 50 package will be available to use and assign within Joblogic.

Once you have done this, select Settings in Joblogic > Library > Tax Rates/Nominal Codes, as applicable.

Check that the tax rates and nominal codes populating your libraries are applicable to you and your Sage 50 package’s code settings.

With regard to tax rates, you will likely find that Sage 50’s system default tax codes of T1 (Standard rate: 20%), T0 (Zero rate: 0%), and T9 (No Tax) already exist in your Joblogic as these are also used as JL’s default codes. This means that, in most cases, the codes used in Joblogic will align with the ones in your Sage 50 account, ensuring smooth transfers of financial data such as invoices, credit notes, and payments.

However, it is still important to double-check that the codes apply to your Sage 50 account and that they have not replicated (the JL and Sage version of the code each exist in the library).

If you find that the system default tax codes of T1 (Standard rate: 20%), T0 (Zero rate: 0%), and T9 (No Tax) do not apply to your Sage 50 accounting package, or that they have replicated, you may wish to adjust or delete them as needed. This can be easily done by selecting the code and clicking the Delete button (provided that the code is not already in use within the system).

Note: The Joblogic T9 code cannot be deleted from the system due to being a foundational code so either delete Sage’s entry of the code and set the JL one in accordance with your Sage package or label it as ‘Do not use’.

Once you are satisfied that the tax rates and nominal codes populating your libraries are correct, they can then be used throughout the Joblogic system and assigned to invoices, credit notes, and payments to allow for a successful sync with your Sage 50 accounting package.

If the Sage 50 Sync Times Out

The connection to Sage 50 may time out after a certain amount of time as a security measure implemented by the accounts package. If a sync takes a significant amount of time to process due to a high number of items, it may time out before processing them all. However, it will still process a portion of the invoices/data. This means that when there is a high volume of records to run, it can take multiple connections/logins to clear them all down.

Sage 50 Suppliers Syncing to Joblogic as Customers

Suppliers set up in Sage 50 may sync across to Joblogic as customers if they are set up as an account that can receive sales invoices within Sage 50. This is to accommodate instances where you may charge/invoice a business that typically acts as your supplier.

If you find that suppliers in your Sage 50 package are syncing to your Joblogic as customers, check the settings of these suppliers in the Sage 50 account to confirm whether the supplier(s) that have synced have been set to be able to receive sales invoices.

Further Support

For further information or assistance with the above, contact our Support Team on 0800 326 5561 or email support@joblogic.com. Alternatively, our Customer Success Management team can be reached by emailing customersuccess@joblogic.com.

Publishing Details

This document was written and produced by Joblogic’s Technical Writing Team and was last updated on the date stated above.

Please note:

The information provided may be subject to change following updates to the system or new app releases.

Details within this guide may vary depending on your Joblogic account’s user permissions and settings or the device being used to access the platform.