For businesses in South Africa, Dext supports two dedicated CSV export formats for Sage Pastel: one for Cashbooks and one for Purchases. This article covers how to set up and use both.
Sage Pastel Cashbooks
Set up categories and payment methods in Dext
Before exporting, make sure your Dext account contains the same categories and payment methods as your Sage Pastel setup.
To set up categories:
In Sage Pastel, go to File > Export/Import and export your General Ledger Accounts as a CSV file. Select the correct range of accounts.
In Dext, go to Business settings > Lists > Categories > Import from CSV and import the file.
When mapping the fields, set Category name to match the Description column in Sage Pastel, and Category code to match the Account number.
To set up payment methods, go to Business settings > Lists > Payment methods and add your payment methods manually. Make sure the references in Dext are identical to those in your Sage Pastel file - the reference is exported as the Contra Account.
Export costs from Dext
Before exporting, add the relevant categories and payment methods to the items in your Costs inbox.
Note: Sage Pastel can only import a single tax rate per receipt or invoice. If an item contains multiple tax rates across several lines, split it into multiple line items before exporting.
To export:
In the Costs inbox, select the items you want to export using the checkboxes. To export all items, select Export all without selecting any items first.
Select Export.
Select CSV, then choose Sage Pastel Cashbooks from the CSV format dropdown.
Set the start of the financial period you're exporting for using the date picker.
Select Export.
Note: The financial period start date must match your Sage Pastel setup.
Import into Sage Pastel Cashbooks
Once you've exported the file from Dext:
In Sage Pastel, go to Process > Cash Book > Process Cash Books.
At the bottom of the Cashbook, select Batch > Import.
Select the file you exported from Dext.
Note: You can only import items from one payment method at a time. If your Costs inbox contains items from multiple payment methods, use the advanced search to filter by payment method before exporting.
Sage Pastel Purchases
Import suppliers into Dext
Before exporting, import your Sage Pastel supplier list into Dext so that supplier data is included in the export.
In Sage Pastel, go to File > Export/Import > Export Supplier Accounts and export your supplier accounts, selecting the start and end of the account range.
In Dext, go to Costs > Suppliers > Import from CSV and upload the file you exported from Sage Pastel.
Export costs from Dext
Follow the same export steps as for Cashbooks above, but select Sage Pastel Purchases from the CSV format dropdown instead.
The export produces a ZIP file containing 2 CSV files:
suppliers.csv - the list of suppliers for the exported items
purchases.csv - the list of exported items
Import into Sage Pastel Purchases
In Sage Pastel, import suppliers.csv using the Import Supplier Accounts function, mapping the 4 fields as shown below:
Once the suppliers are imported, import purchases.csv into the Suppliers Journal or Purchases.