Skip to main content

AutoCount GridToExcel Plugin User Guide

Follow this step-by-step AutoCount GridToExcel Plugin user guide to set access rights, export the Debtor Aging Report to Excel, and review the saved workbook.

Before you begin

Before you begin: Check that GridToExcel is available in the correct AutoCount account book, that you have the Debtor Aging export permission, and that the report date and criteria are correct. Exported debtor information is confidential.

01. Set GridToExcel Access Rights

GridToExcel uses AutoCount’s existing Debtor Aging export permission. The plugin also provides a separate permission for viewing its license information.

  1. Open General Maintenance > Access Right Maintenance.
  2. Select the required user or user group.
  3. Allow the user to export the Debtor Aging Report.
  4. If license-screen access is needed, enable SL Plug-In > GridExportToExcel Plug-In > Show License Status.
  5. Save the access-right settings.

Check: Confirm that the user can access the required export function.

02. Export Debtor Aging to Excel

Use the Export to Excel command on the standard Debtor Aging Report. The file follows the selected report date and criteria.

  1. Open the standard Debtor Aging Report in AutoCount.
  2. Choose the required report date and debtor criteria.
  3. Click Export to Excel. If results have not loaded yet, the plugin runs the normal inquiry.
  4. Choose the folder and file name in the save dialog.
  5. Click Save. The plugin saves an .xls file. The default file name starts with Debtor Aging for and includes the company and date.

Check: AutoCount should show the successful-save confirmation.

03. Review the Exported Excel File

After the export, AutoCount asks whether you want to open the saved workbook.

  1. Click Yes to open the workbook, or No to stay in AutoCount.
  2. Review the company name, DEBTORS AGING heading and report date.
  3. Inspect debtor details, document information, outstanding amounts and aging values.
  4. Compare the workbook with the original report criteria and sorting before distributing it.

Check: Confirm that the report date and debtor figures correspond to the intended AutoCount inquiry.

Troubleshooting

Export to Excel is unavailable or blocked
Check whether the user has the required Debtor Aging export permission in Access Right Maintenance.
Unexpected debtor records or amounts
Review the report date, criteria and sorting, rerun the inquiry, then compare the data against the report.
Cannot locate the saved workbook
Look in the selected save folder and check the .xls file name.
Workbook does not open
Try opening the saved .xls file with compatible spreadsheet software; note the exact error for support.

Frequently Asked Questions

Does GridToExcel export every AutoCount report?

The documented function supports the standard Debtor Aging Report; support for other reports has not been confirmed.

What format is the exported workbook?

The plugin saves the report in .xls format.

Does the export contain document-level aging information?

Yes. Applicable debtor document details and aging values are included.

Does it follow the selected report date?

Yes. The exported data uses the relevant report date, selection criteria and sorting.

Can I share the Excel report?

Yes, with authorized recipients. Keep customer financial information confidential.

Resources and Technical Support

Find more accounting and plugin documentation in the AutoCount Knowledge Base and Advanced Plugin Guides.

Need assistance with GridToExcel?

Our team can help with access rights, plugin setup and Debtor Aging report exports. Share your AutoCount version and error details when requesting support.

Contact Support