Menu
Home ›Sage 50 ›PostTrans for Sage 50 Download

POSTTRANS FOR SAGE 50

Your next time-saver.
Starts here - Download

Bring your Excel workflow into Sage 50. Download PostTrans and try it with the demo company.

Choose your installer ↓ Watch the installation guide ↗

Before you start.

Install while signed in as the Windows user who will use PostTrans. Installation is per user and does not require administrator rights. Choose the installer for your Sage version; the V30 onwards installer requires 64-bit Excel and Sage 50.

FROM DOWNLOAD TO YOUR FIRST IMPORT

Make yourself at home.

  1. Create your PostTrans users.

    In Sage 50, use Settings → User Management → Users (or Access Rights) to create a separate login for each PostTrans user, such as PT1 or PT2. Set these up in every company, including Demo Data.

    Sage and PostTrans cannot share a login at the same time. With a single-user edition, close Sage while using PostTrans. Sage 50 Accounts Professional supports unlimited additional PostTrans users; lower editions allow up to six.

  2. Install and test in Excel.

    Open Excel and select the PostTrans tab. Press Help and choose the first example sheet. Follow the instructions in the test spreadsheet that opens after installation.

    In the demo company, press Extract, make a small change to one record, then press Import. Enter your company name if prompted on first use; you may need to press Import again. Extract the data again to confirm your change.

  3. Ready for live use?

    Evaluate the full product with a Sage demonstration company. Live-company use requires a subscription and card details. Billing is monthly; future renewals can be cancelled at any time.

    Press Setup, then View your Accounts and Billing on the PostTrans toolbar to purchase or manage your subscription.

    Compare Sage 50 plans ↗

Find your PostTrans toolbar

After installation, Excel has a new PostTrans tab. The test spreadsheet opens automatically; follow its instructions to get started.

PostTrans Excel toolbar and its Help, Extract and Import controls

SEE IT IN ACTION

A little guidance. A confident start.

Follow the Sage 50 installation, test and upgrade walkthrough. Sage 200 follows similar steps, but does not require separate PostTrans user logins.

Player not showing? Watch the installation video on YouTube ↗

Setting up a team?

Use a shared network folder to distribute upgrades, or follow the guidance for remote desktop and large networks.

Network installation ↗
Version history

Versions

  1. PostTran50 Version 34.0.0 V34

    • 34.0.0 Version for Sage V34
    • Took out the trigger for 64 bit installation New upgrade routine

  2. PostTran50 Version 33.0.1 BETA: Upgrade manager

    • Took out the trigger for 64 bit installation
    • 202607022009 Add upgrade manager

  3. PostTran50 Version 33.0.0 Release for Sage 50 V32

    • For Sage 50 V33

  4. PostTran50 Version 32.0.2 Release for Sage 50 V32

    • For Sage 50 V32 on request

  5. PostTran50 Version 31.0.0

    • Version for Sage 50 V31
    • 202409171709 Set Service/Product type on post
    • 202409171708 import SQI new type
    • 202403200836 '64 bit com Sage 50 v30

  6. PostTran50 Version 30.0.0

    • Version for V31
    • 202409171709 Set Service/Product type on post
    • 202409171708 import SQI new type
    • 202403200836 '64 bit com Sage 50 v30

  7. PostTran50 Version 30.0.0

    • 30.0.0 for Sage 50 V30
    • 202403121527 Added Company Name to Receipt extract

  8. PostTran50 Version 29.0.6

    • Flg_isTransactionPost gets reset on every transaction
    • Better waring if posting zero value item line on PI,SI,PC,SC, etc. As it not allowed
    • 202307041240 SIA/PI Nett should be * Qty
    • 202307031022 - Cust Ref did not work
    • 202304201531 Recipt matching now skips errors 29.0.3

  9. PostTran50 Version 29.0.1

    • 202302101217 29.0.1 Addedd new Sage 2023 fields
    • 202302101317 Set printing to OFF be default
    • 202302101417 Automatically runs the 64b it code install

  10. PostTran50 Version 29.0.0

    • New version for Sage 50 2023
    • 202302011000 - Refresh license if gone to portal automatiaclly

  11. PostTran50 Version 28.0.23

    • Tag properties window enhancement

  12. PostTran50 Version 28.0.22

    • 202211281000 - Edit lines - Tag window alteration
    • 202212061454 - Added Customer/Supplier delivery addresses import/edit
    • 202212021006 Include S1,2,3 in stock search

  13. PostTran50 Version 28.0.20

    • Upgraded Addin Express

  14. PostTran50 Version 28.0.19

    • Better feed back when geting a list on BOM,Cust,Supp and Products
    • 202209291625 Vat rate was rounded up in certain circumstances

  15. PostTran50 Version 28.0.17

    • Better feed back when geting a list on BOM,Cust,Supp and Products '202208301508 Add ability to get discount matrix entries by stock list
    • 202208301355 Price list did not extract from a list of codes. Added
    • 2022083013232 filter price list extraction by stock codes
    • 202208311258 Non cash accounting could not post receipts to allocate
    • 202208302100 Speed up the writing of outstand trans
    • 202208301553 Massive speed increase in reading outstanding transaction when matching
    • 202208301453 Memory releases
    • 202208301353 More changes for Euro version of PostTrans
    • 202208291025 When importing will skip filtered rows if applied
    • 202208291125 Occasional error for one customer when extracting the Large Price matrix - Excel may be busy and gives an exception
    • 202208291225 Transaction Header should default to account currency when not pro version. For Euro versions of Sage 50

  16. PostTran50 Version 28.0.8

    • 202207271155 Euro version with home currency of 2 required PRO version. Fixed
    • 202205201024 29.0.4 Could not update THCustRef on SSI - Fixed
    • 20220702 Failed to reset THCustRef and THCustRef2 if blank on multi line Trans import
    • 29.0.6 On Euro system said needed PRO version for multi-currency - Fixed

  17. PostTran50 Version 28.0.3

    • V28.0.3
    • added Sage.Reporting.Engine.Integration.dll to install since v28 no longer includes this file
    • Causing failed installs on new machines <br Improved message about firewall if a problem <br Added reset registration to Setup window

  18. PostTran50 Version 28.0.1

    • V28 2022
    • V27.0.24 Could not select Salesw VAT control account from lookup -Fixed

  19. PostTran50 Version 27.0.13

    • 20210826 copy back registration details back to common directory
    • 202108261200 Send common network patht to server
    • 202110121552 VAT Nominal rejected if VAT Calc gave more that 2 DP. -Fixed

  20. PostTran50 Version 27.0.7

    • 202012231333 - Nominal gave a strange error if did not balance due to more than 2 dp figures
    • 202012240717 - Sage50priceListPrice added PrProdCostDisc
    • 202101231229 - Added GO/GI
    • added fields TLTransRef and TLTransRefType fro GI/GO
    • added TLLocation
    • 20210820 - Get network directory from Clinet Install

  21. PostTran50 Version 27.0.6

    • 202012071310 Select different companies
    • Added option 'Options >> Clear Cached Data' in [Setup]

  22. PostTran50 Version 27.0.4

    • Added PA Payment on allocation

  23. PostTran50 Version 27.0.3

    • 202011211731 - Fix error where it does not know the correct Row numbers, all 0, which causes all sorts of problems

  24. PostTran50 Version 27.0.2

    • 202011121711 - For some reason required Boolen to be filled in. Fixed

  25. PostTran50 Version 27.0.1

    • Added Promo code stuff

  26. PostTran50 Version 27.0.0

    • Cound not update Country of Origin or Import Com Desc
    • Compiled for V27

  27. PostTran50 Version 17.0.103

    • Added a Support Button 101
    • Export Invoice No when extracting Outstanding Invoices

  28. PostTran50 Version 17.0.100

    • THImportFullName has been exctended to 500 chars
    • Paul Unsworth- AMACOR
    • Found abug in displaying Delivery address

  29. PostTran50 Version 17.0.98

    • Fix to all boolean values

  30. PostTran50 Version 17.0.97

    • Added tag TLForceNewTrans to Trans,Nom and Adj
    • Alterewd BP to allow multiple lines

  31. PostTran50 Version 17.0.96

    • 17.0.96 Payments and reciepts post single lines now.

  32. PostTran50 Version 17.0.95

    • 201912301218 Replace header tags if already added

  33. PostTran50 Version 17.0.94

    • 201912171031 Now creates program icons if not installed through normal Installer
    • Can now define a network folder to coordinate network upgrades
    • A few other minor improvements for manging installation on citrix All examples in xlsx format

  34. PostTran50 Version 17.0.86

    • 201911210933 File import multiple files at once
    • 17.0.86 Did not look up default VAT code if no stock item, and “Use default…” not ticked - Fixed

  35. PostTran50 Version 17.0.85

    • BP,Bank Payment,BR,Bank Receipt,CP,Cash Payment,CR,Cash Receipt,VP,Visa Credit Payment,VR,Visa Credit Receipts,SCAT,Sales Credit Audit Trail

  36. PostTran50 Version 17.0.84

    • Import SA, SR and PR transactions

  37. PostTran50 Version 17.0.83

    • Drag and Drop for tags between tag row and Header '201911052120
    • When importing Transaction acept TLDesc or TLProduct as EOF '201911071107
    • A few improvements to ADJ
    • 201911081222 SI payment allocation to SR

  38. PostTran50 Version 17.0.81

    • 17.0.81 fixed error Error 1 index specified for retrival when posting a PI

  39. PostTran50 Version 17.0.80

    • Compatible with Sage V26

  40. PostTran50 Version 17.0.77

    • Fixed bug where the Assembly level was wrong after BOM Import

  41. PostTran50 Version 17.0.76

    • Enabled basic version of Sage 50

  42. PostTran50 Version 17.0.75

    • Added the ability to set 'Taken By'

  43. PostTran50 Version 17.0.74

    • Added the ability to set date and ref on each line of Product adjustment

  44. PostTran50 Version 17.0.73

    • Improved the [Clear] button. Now copies down top 10000 lines or to end of sheet, which ever is the larger

  45. PostTran50 Version 17.0.72

    • Made Option 'Post discount as diff Standard price-TLUnitPrice' off by default
    • as confused customers
    • Extended Price Matrix DP round ing to 6dp

  46. PostTran50 Version 17.0.71

    • Bank : Extract showed the currency one out
    • BOM : Could not search for a parent code unless was already a BOM. Fixed
    • 201906041526 Did not allocate SR to SO if in currency
    • 201906171226 Did not post VAT journals fixed
    • 201906171355 Manual Match of recipts need to set Tax code on Sr to same as Simply

  47. PostTran50 Version 17.0.70

    • 201905301535
    • BOM's: when searching for BOM with code longer than 8 chars did not work
    • First BOM item did not have product description in PbParentCode
    • On specific site returned INVALID parent records. Made ignore blank primary key values
    • Used to lookup BOM Descripotion, even though has already loaded it. Now uses current record
    • Setup:Extened the size of defined company codes
    • Recipts: Better explaination of error when posting recipts to differeing currencies
    • Now only extracts outstanding records for same currency as selected bank account
    • Posts in Forieng currency
    • If rounding erro then compensate
    • Standard Prices: When import set to 2 dp by deafult
    • If importing SI to currency account added tax if not specified not to
    • If slow to update, 250 milli secs, takes use to page on how to imrove speed RE-INDEX

  48. PostTran50 Version 17.0.69

    • Bug where if Stock has no Stock categories, - extract is really slow, since tries to read 1000 categories which are empty, over and over again,

  49. PostTran50 Version 17.0.68

    • Restricted PRO tags

  50. PostTran50 Version 17.0.68

    • Tag Properties window added

  51. PostTran50 Version 17.0.66

    • New import with payments example and changes around this functionality to simply

  52. PostTran50 Version 17.0.65

    • Fixed a bug in supplier BACS setting

  53. PostTran50 Version 17.0.63

    • New Function tag PrNewInStk column in products fro stock take
    • Added new example for Stock Take
    • Add a switch 'Stock Take:Only read PrNewInStk tag value'

  54. PostTran50 Version 17.0.62

    • Bom fix

  55. PostTran50 Version 17.0.61

    • Supplier Prices now create parent record on the fly
    • Many other minor improvements

  56. PostTran50 Version 17.0.60

    • Uses new print object V24 onwards

  57. PostTran50 Version 17.0.59

    • Can now reset registration password from application

  58. PostTran50 Version 17.0.58

    • For sage V2019

  59. PostTran50 Version 17.0.57

    • Fixed a bug in receipt allocation where did not work if the Trans did not match the spit record number
    • Journals now return the trans number

  60. PostTran50 Version 17.0.56

    • Fetch outstanding transaction ignores deleted transactions
    • Treats Invoice Ref as string. Before Long number

  61. PostTran50 Version 17.0.55

    • Unhide TLExterRef on Noms

  62. PostTran50 Version 17.0.54

    • Added an option to allow code to activate the import without messages poping up

  63. PostTran50 Version 17.0.53

    • Improvement in Password retention

  64. PostTran50 Version 17.0.52

    • Posting Product adjustment zero'd the Cost Price, because no cost specified
    • Better warning on Data Loss if tag added to sheet

  65. PostTran50 Version 17.0.51

    • Added 'THPrintEmail' and 'THPrintNoCopies' tags to allow auto e-mail and print after import

  66. PostTran50 Version 17.0.50

    • Bank account Import fixes

  67. PostTran50 Version 17.0.49

    • Added Import Bank Accounts
    • All Text fileds are trimmed by default, Add ' to the end of the tag name to stop this

  68. PostTran50 Version 17.0.48

    • New Nominal Codes example
    • Bug fixes when updating Nominal Codes
    • New - Multi-posting functionality, see
    • Formats all text columns as text when adding to template
    • Already in use message improved
    • Negative item line
    • Nominal Account update on web site
    • Project import added

  69. PostTran50 Version 17.0.47

    • Few bug fixes and improvements

  70. PostTran50 Version 17.0.46

    • Included the forms .dll

  71. PostTran50 Version 17.0.45

    • Did not switch company if sheet was changed - 20171005092457
    • Validates negative values on all lines and rejects (Because Sage do not allow IS_NEGATIVE_LINE to be set, and thus PostTrans cannot handle negative lines on Invoices. For Christ sake Sage)
    • Validate if Nominal specified, when Fund Specified
    • Added a Contra fund tag for Contra Journals

  72. PostTran50 Version 17.0.39

    • Alterations to the way discount is handled if account already has discount

  73. PostTran50 Version 17.0.38

    • Shows company name in Import/Extract better
    • Added Charity example
    • Added Fund ID to SI/PI and Nominal import

  74. PostTran50 Version 17.0.36

    • Added functionality for remote purchase orders from multiple suppliers

  75. PostTran50 Version 17.0.35

    • Better error logging Sage 2018 enabled

  76. PostTran50 Version 17.0.34

    • Added new switch to stop getting customer discount when selecting Product
    • PIA fixed Qty calc

  77. PostTran50 Version 17.0.31

    • Improments to open account screen Chain posting

  78. PostTran50 Version 17.0.29

    • Fix Could not import new supplier price list

  79. PostTran50 Version 17.0.28

    • Added Tags to work transaction value back from Inclusive VAT
    • Added Tags to add additional lines to transaction

  80. PostTran50 Version 17.0.27

    • 20170530121349 Option to update Ledger when posting to Invoices/Credits
    • Can now add 4 extra stock items specified on each line for sundry items
    • Did not post to default Sales GL is certain obscure instances
    • 20170607162752 PIA adjustment
    • 20170608093542 Fix rounding Problems with extra line 56
    • Added new Special Prices example
    • Added new Assets example
    • Added new File import example to show add lines, payment and rounding
    • Added Search columns on Customer, Supplier, Price, Product, BOM and project sheet
    • THNetDiscount now is the sum of values in lines

  81. PostTran50 Version 17.0.26

    • The ablility to update ledger automatically after posting Invoices

  82. PostTran50 Version 17.0.24

    • Added THOrderNo
    • Did not set Due Date if not specified
    • New File import example

  83. PostTran50 Version 17.0.23

    • Slight speed increases
    • Better file import example

  84. PostTran50 Version 17.0.22

    • Speed improvement in registration system
    • AutoComplete only gets turned off in In-CellSearching columns
    • Fixed bug where extra lines on order did not have correct Line date
    • Manual Tax and currency fixes
    • Tried to import blank transaction if all posted on sheet, when importing multiple transactions in rows
    • Allowed Extract with no License

  85. PostTran50 Version 17.0.21

    • UI improvements

  86. PostTran50 Version 17.0.18

    • Added the ability to delete a Price list at the top level if all child prices have been deleted first

  87. PostTran50 Version 17.0.17

    • Registration bug fix

  88. PostTran50 Version 17.0.16

    • Speed improvements
    • Improvement to Login window to help reduce confusion

  89. PostTran50 Version 17.0.15

    • Fixed IN-Cell Searching not working due to changes in License routine

  90. PostTran50 Version 17.0.14

    • Fixed an issue where the Database was closed while extracting data

  91. PostTran50 Version 17.0.13

    • Supports 64 bit Excel

  92. PostTran50 Version 17.0.7

    • Speed improvements with registration.

  93. PostTran50 Version 17.0.5

    • BOM import did not like stock items with no ', Description'
    • Opening new Product template crash

  94. PostTran50 Version 17.0.4

    • Bug fix when importing Prices with markup was defaulting to add 2 to the value

  95. PostTran50 Version 17.0.2

    • Improvements in Help in examples + Sage 50 2017

  96. PostTran50 Version 16.0.22

    • Full eval 12/12/2016
    • Sales Receipts
    • User list on log in
    • Load of bug fixes '201609120742 Took out network folder and started sub scription based

  97. PostTran50 Version 16.0.19

    • PI and PC added, with all fields
    • Shows split number on leger properly, and returns correct no after post PI/PC
    • Show tags in tag window
    • Transaction browser
    • Currency fixed

  98. PostTran50 Version 16.0.15

    • Added PI as an import
    • Added Job costing
    • If unit price<>0 and Qty =0 then Qty=1 Currency bugs killed

  99. PostTran50 Version 16.0.13 SSI

    • New Adx Loader. Works with Sage 50 2011 onwards

  100. PostTran50 Version 16.0.12 SSI

    • Added module restrictions

  101. PostTran50 Version 16.0.11 SSI

    • More bug fixes and examples

  102. PostTran50 Version 16.0.10 SSI

    • More bug fixes and examples

  103. PostTran50 Version 16.0.8 SSI

    • A lot of work on BOM

  104. PostTran50 Version 16.0.6 SSI

    • Cursor Path fix

  105. PostTran50 Version 16.0.3 SSI

    • More demo examples

  106. PostTran50 Version 16.0.2 SSI

    • Added Sales Service Credit Notes and Credit Notes

  107. PostTran50 Version 16.0.1 SSI

    • Added Sales Service invoices

Need a hand getting started?

Tell us what you’re trying to do. We’re here to help.

Talk to us ↗
⌃