Sage Accounts

Sage Accounts

Sage Accounts Import

In GP-Billing, click on the  icon on the blue navigation bar and select “Account”.

Click on “Search”

Add a filter to include only those records last modified since the previous import was performed i.e. >= 22/06/2021.


Click the Export button 

Click “Save As” and download this to a spreadsheet – open it in Microsoft Excel

Select all records, right click on the spreadsheet and click “Copy”


Delete all rows from the “Accounts_GPBilling” tab.

Paste the results into cell A1 on the “Accounts_GPBilling” tab.

The formatted data for import into Sage can be found on the “Accounts_Sage” tab.

Sage Transactions Import

In GP-Billing, click on the   con on the blue navigation bar and select “Reports”.

Click on the “Transactions” report

Specify the “Date From” and the “Date To” and click the “Income Code” checkbox the click “Refresh”


Click the Export button

Click “Save As” and download this to a spreadsheet – open it in Microsoft Excel

Select all records, right click on the spreadsheet and click “Copy”


Delete all rows from the “Transactions_GPBilling” tab.

Paste the results into cell A1 on the “Transactions_GPBilling” tab.

The formatted data for import into Sage can be found on the “Transactions_Sage” tab.


    • Related Articles

    • How to View All Accounts in GP-Billing

      To view all accounts, press the magnifying glass at the top of the page. In the image below this has been circled in red. Then click the "Account" hyperlink (the blue text) to open the "Search Account" page. Without typing anything into the search ...

    • Lost Access to Practice Admin Account

      If your practice finds itself in a situation where access to all practice admins accounts has been lost, due to staff changes etc. A scanned document on letterheaded paper requesting the deactivation of the old account with the name of the new ...

    • Test Your Knowledge

      Each quiz has a series of 6 questions helping you to test your knowledge of GP-Billing. Please see attachments for downloadable links to the following quizzes: Raising Bills Receipting Income Managing Accounts Reporting System Configuration

    • Quickbooks

      The following guides you through the steps required to transfer data between GP Billing and QuickBooks. You will need a copy of the [Quickbooks.xlsm] or [Quickbooks – SinglePatientAccount.xlsm] spreadsheets and Microsoft Excel 2010 or above. Please ...

    • Using Unallocated Account Credit

      Using Deposits or Ad-hoc Credit Notes will leave unallocated credit on accounts. To use this credit, open the payment screen. One of the ways this can be done is by opening the account with the unallocated credit, opening the Outstanding Bills tab, ...