Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel

This is a modified Dynamics GP report (see download) I’ve provided to my clients for years that can be exported to a text file and imported into excel that includes the customer ID, name, and the aging columns. Through GP security, you can only have one modified report for each user and company if you’re running a shared modified reports dictionary for each workstation. What this means is if you already have an existing modified historical aged trial balance detail report you may have to provide a separate login or shortcut to this report to have access to both. Here’s a screenshot of the report in excel.

You have to add totals and grand total line, be sure to exclude the “Original Amount” column.


Download report



Download report


After you download the package(s) from above by right-clicking and choose ‘save as’, you can import it in version 10, 2010, 2013 by going to Microsoft Dynamics GP>>tools>>customize>>customization maintenance and choose import. Before doing so, be sure to back up your modified reports to ensure nothing is overwritten.

If you need the summary trial balance export packages just create a comment below and I will email them to you.

This entry was posted in Dynamics GP. Bookmark the permalink.

87 Responses to Export the Dynamics GP Payables or Receivables Historical Aged Trial Balance to Excel

  1. Eric says:

    Hi Steve,

    Thank you so much for putting this together and sharing your work with all of us! I know I can speak for everyone here, this has made life so much easier when dealing with these reports.

    Can you please send me the package for the customized payables detail report?

    Thanks again Steve!

  2. Mel says:

    Hi Steve,

    Can you please let me have the PM Summary and detail reports?

  3. Phil Justice says:

    Hello Steve,

    Could you please send me the Detail and Summary AR Historical Aged TB’s. I am having a little difficulty trying to download the detail from the site.

    Thank You

  4. Keith says:

    Can you please send a copy of the payables report and the summary report. This will save me the time to do the same all accountants want to send everything to Excel.

    Thank you

  5. Robert says:

    Can you please provide me with the AP trail balance and Summary please?


  6. John says:

    Hi Steve,
    I know you posted this a few years ago but that AP HATB package file would save me some time.

    Great work, thank you!

  7. Lisa Sorensen says:


    Can I get a copy of the Payables and Summary TB export package as well. This is great to have. Thank you for being generous and sharing it.

  8. Steve says:

    Unfortunately I don’t have the multicurrency version.

  9. Alicia says:

    Hi Steve,

    Can I get a copy of the Historical AP TB Detail and Summary export package as well.

    Thanks sharing!!

  10. Albertha says:

    We’ve customized the MC Payables Historical Aged TB (Detailed). For some reason, after the customization, I’m unable to save to file as text, Comma- or Tab-delimited. Any ideas?

  11. Steve says:

    Try making sure all the fields in each column are the same width, or try going back to the original to see if you have an environment issue, I’m not sure otherwise.

  12. Julio says:

    Hi, I can’t download the RMHistoricalAgedTrialBalanceDetail.package Can you help me please.

  13. Lindsay says:

    Hi there,

    can you please send me the package for AR and AP?

    thank you,

  14. Clark says:

    Hi Steve,

    Can you send me the packages for the summary of both AR and AP?

    Thank you,

  15. Brenda says:

    Can I please get the package file for the AR and AP reports, it will not download

  16. Travis says:

    Hello – Could you please send me the packages for summary trial balance? Thanks in advance. Good work!

  17. Carly Dartez says:

    Can you send me the summary trial balance export packages

    Many thanks!

  18. Mark Wiley says:

    Thanks Steve. I’d like the summary versions, if possible. Thanks for sharing.

  19. Nikki Toole-Hebert says:

    This looks great could you send me the AR and AP detail Trial Balance Reports.
    Thank you for this.

  20. Kerri Reinholtz says:

    This is great – can you send me the package for the Receivables Historical Aged Trial Balance Reports? I am having trouble downloading/saving it.

    Thank you!

  21. Kim Harold says:

    Can you send me the TB detail and summary report packages as well?

    Thanks! Kim

  22. D. Lawson says:

    Hi Steve,

    Can you please send the PM Historical aged Trial Balance Summary? When i went in and stripped the report myself and try to run it i get the “ILLEGAL SYNTAX” error. I did not add any new fields. Only removed fields and move fields between headers. Can those two actions create bad syntax?


  23. Steve says:

    Yes, deleting fields can sometimes do this if the report relies on them. I recommend reimporting the package then making the fields you don’t want invisible.

  24. Cale says:

    Hi Steve,

    Thanks for posting! Would you please send me the summary trial balance export packages for both? Much appreciated!


  25. Tina says:


    May I ask for a copy of the summary reports please?


  26. Tania Mofflin says:

    Can I please get a copy of the summary versions, that would be great.



  27. Charles Allen says:

    Steve, would you send me the summary Receivables report?

  28. Charles Allen says:


    Great job on making these reports clean and exportable to Excel. Thank you for your work!

  29. Salida Kaing says:

    Hi Steve,

    Can you please send me the Summary AR Historical Aged TB’s?

    Thank you!!

  30. Salida Kaing says:


    Can you send me the package for the Summary Receivables Historical Aged Trial Balance Report?


  31. David Forman says:

    Thank you!!!!!!!

  32. Mandy says:

    can you please send me the AP& AR summary historical aged trial balance report? My email is myan@thisisamg.com. Thanks a lot!

  33. Laine Guillot says:

    Hey Steve, can I get all 4 reports sent to me? Clicking the download just shows me the text and doesn’t download the file. I’d also like the summary reports as well.

    Thanks, Laine

  34. Linda says:


    Can you provide instruction what to do next after importing the RM download file? How to generate the Aged Debtors Trial Balance in excel form?

  35. Steve says:

    This was from an earlier post, try this:
    Several things can go wrong, try following these instructions
    1. Give yourself security access to the report
    2. On the report destination, be sure to mark file and choose ‘Tab – Delimited’ on the file format
    3. Be sure you know where you’re saving it and the file extension is txt.
    4. Open up excel, then choose file>>open
    5. On the file types choose text, or in the file name you can choose *.txt and click the enter key to display the file types, then open the file
    6. This brings you to the text import wizard, choose delimited and choose next
    7. For the delimiters mark the tab field, choose next and finish
    8. From there you sort out the things you don’t need, clean up and enter subtotals

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>