Skip to main content

Sage 50 export

Use Reports > Accounting > Sage 50 to download a general-journal text file for Sage 50. You need Premium.

Prepare the export​

  1. Configure accounting codes to match the accounts in your Sage 50 company file.
  2. Set From and To for the period you want to import.
  3. Review the preview of the first five journal entry groups. The download includes every matching group.

Sage 50 report previewing dated journal groups and balanced account amounts before download.

Check the dates on deposits, refunds and withdrawals. They are separate accounting events and can fall in different periods. See refunds and corrections.

Blank codes block the download​

If any included entry has a blank code, the download is blocked. Correct missing settings and use Fill Blank Codes on the Ledger, then review unresolved entries before trying again. Zero-value entries with blank codes can also block the download, even though zero lines aren't written into the Sage file.

Filling blank codes doesn't replace an existing code. Changing settings doesn't recode entries already recorded. Review the file before importing it.

File layout​

Select Download to save accounting-sage50.txt. The file has no column-header row. Each group begins with:

MM-DD-YY,"source","comment"
PartContents
DateMM-DD-YY
SourceJournal entry group ID, limited to 13 characters
CommentFirst item description when there is one, limited to 39 characters; blank for payment and deposit groups

Each following account line has this form:

code,amount

code is the accounting code. amount is positive for a debit and negative for a credit. Zero lines and groups with only zero amounts are left out.

For example, an untaxed $25 sale could use account codes 1100 for A/R and 4000 for Revenue. Its account lines would be:

1100,25.00
4000,-25.00

Those codes are examples. Use the codes from your own chart of accounts. Source IDs and comments can be shortened in the file; use the Ledger CSV when you need to compare full group IDs and descriptions.

Import into Sage 50​

  1. Back up your company file.
  2. Check the import in a test or backup copy first.
  3. Use Sage 50's general journal import and select accounting-sage50.txt.
  4. Compare accounts, dates, positive debit amounts, negative credit amounts and totals with Curling IO.
  5. Check source IDs and comments, allowing for their length limits.
  6. Record the date range and journal groups imported, and keep the file.

Downloading doesn't mark entries as exported. Importing the same entries twice can duplicate them in your books. Check overlapping periods before importing. A refund or scheduled-payment cancellation can rebuild an order's missing sale and payment entries, plus deposits for payments with a deposit date, including Stripe fee lines. These use original dates, so an earlier period can contain new entries alongside ones you already imported.

Use Reconcile your books to check the result.