This program can import and export Transactions into the Sage 50 Audit Trail from a CSV file. You may have noticed that the standard transaction import in Sage 50 creates a new header for every split.

Our program will group together like transactions as multiple splits under a single header in the same way that Sage 50’s batch entry screens do. This program can also import Project Codes, Cost Codes, Disputed Reason and Due Date.

Are you a Charity and use Sage 50 or 50cloud Accounts? If so this is the number one Sage Add-On Tool for you as it can import Fund Numbers, Donations, set Gift Aid and Small Donation flags all from a CSV file.

Core Features of Adept Sage 50 Transaction CSV Add-On

  • Correctly creates a single header with multiple splits for invoices and other grouped transactions.
  • The CSV file contents are displayed, along with any error messages, before the import takes place.
  • Optionally the column headings in the first line of the CSV file can be used to define the fields that the data should be imported into.
  • Export option will load your CSV template with transactions from your current Audit Trail.
  • New export only field TRAN_NUMBER can be used in a template to include Transaction Numbers in an exported CSV file.
  • New field HEADER_DETAILS will allow you to import the Header Details field separately from the Split Details field.
  • Define a default value for any column by adding =Content to the heading row field name eg: TYPE=SI as the heading for a blank column means that all the transactions in the CSV file will be SI transactions.
  • The CSV file format is based on Sage’s standard CSV file layout with the addition of extra columns for the additional functionality.
  • Will import SR and PP transactions with automatic allocation by invoice number.
  • New configuration options allow SR and PP transactions to be allocated using a reference held in any of the invoice’s reference or detail fields.
  • Trigger the automatic allocation of any transactions using dummy transaction types SM and PM.
  • SM and PM List Mode allows you to match a large number of invoices against a single payment. 
  • Import a Bank Transfer using dummy transaction type BT.
  • Import eBanking payment types PP and PA by putting (BACS) in the reference.
  • Import Charity Donations using dummy transaction types BD, CD and DN.
  • Automatically set Gift Aid and Small Donation flags on Donations.
  • Import Invoice and Payment together using dummy transaction types SB and PB.
  • Payments for consecutive SB or PB transactions are grouped into one SR or PR when the Payment Ref and other header fields are the same.
  • Optionally create a new Customer or Supplier record if the Account Reference is not found.
  • Optionally move the CSV file to an Archive folder after it has been successfully imported.
  • Optionally monitor a specified folder for new CSV files and import them automatically.
  • In a multi company Sage environment the company that each transaction should be loaded into can be specified in the CSV file.
  • You do not have to log other users out of Sage while using this Add-On Tool.
  • The program can be run from a button on the Sage Transactions or VAT module (dependant on Sage version).

Add-On Compatibility and Pricing

  • Compatible with the UK Edition of Sage 50 & 50cloud versions 8 to 26.
  • Unless otherwise stated, also works with any minor version numbers such as v25.2 or v26.1
  • Adept Add-Ons are backwards compatible when it comes to Sage versions, most go back to v8
  • Web Update facility to keep your program up to date, accessed via Menu>About.
  • Only £150.00 + VAT for a company wide licence plus Annual Renewal Fees.
  • Adept Add-Ons are Multi User at no extra cost.
  • Thirty day Free Trial available.
  • The trial version is limited to a 10 Row CSV file per import.
Get Trial

Transaction CSV in action

Adept are Sage Platinum Partners for Sage 50 and certified Sage Developers