AutoCount GridToExcel Plugin User Guide
What Is AutoCount GridToExcel Plugin?
The AutoCount Grid to Excel Plugin helps businesses export Debtor Aging Reports directly from AutoCount Accounting into Microsoft Excel. With a simple export function, users can transfer debtor balances, document details, and aging information into an Excel spreadsheet without manually copying and reformatting report data. For businesses that regularly review outstanding customer payments, the Grid to Excel Plugin simplifies accounts receivable reporting, supports financial analysis, and makes debtor aging information easier to share.
Why Use AutoCount GridToExcel Plugin?
Reviewing customer outstanding balances often requires additional analysis and reporting outside accounting software. The Grid to Excel Plugin simplifies this process by making Debtor Aging information available in Excel.
Eliminate Manual Data Copying
Export Debtor Aging information directly to Excel without repeatedly copying and pasting accounting report details.
Simplify Debtor Aging Analysis
Use exported debtor balances, document details, and aging periods for further analysis in Microsoft Excel.
Improve Financial Report Sharing
Share exported Excel reports with management, accounting teams, and other authorized recipients who may not use AutoCount.
Save Time on Monthly Reporting
Reduce repetitive report preparation when reviewing outstanding receivables during monthly financial reporting.
Key Features of AutoCount GridToExcel Plugin
Direct Debtor Aging Excel Export
Export the standard AutoCount Debtor Aging Report directly into an Excel workbook through a dedicated export function.
Detailed Debtor & Document Information
Include debtor account details, relevant transaction information, outstanding balances, and aging values in the exported report.
Report-Based Excel Output
Generate Excel data based on the selected Debtor Aging report date, criteria, and applicable sorting.
Permission-Controlled Export
Use AutoCount’s existing Debtor Aging export permission to control which users can export the report.
Who Should Use AutoCount GridToExcel Plugin?
Accounts Receivable Teams
Ideal for accounting personnel who regularly review outstanding customer balances and prepare debtor aging reports.
Credit Control Departments
Suitable for teams monitoring overdue customer payments and analyzing outstanding receivables.
Accountants & Finance Executives
Helps accounting professionals export detailed aging information for financial review, reconciliation, and reporting.
Finance Managers & SME Owners
Useful for decision-makers who need accessible debtor aging information for financial monitoring and management discussions.
How AutoCount GridToExcel Plugin Works
A. Access Rights
GridToExcel uses AutoCount’s Debtor Aging export permission before it allows an Excel export. Theplugin also registers a Show License Status access right under its SL Plug-In access-right group.
1. Open General Maintenance > Access Right Maintenance.
2. Select the required user or user group.
3. Make sure the user is allowed to export the Debtor Aging report. If this permission is not available, theplugin stops the Excel export.
4. If the user needs to open the plugin license screen, enable SL Plug-In > GridExportToExcel Plug-In>Show License Status.
5. Save the access-right changes.
B. Export Debtor Aging to Excel
GridToExcel adds an Export to Excel button to the standard Debtor Aging Report. The exportedfileiscreated from the Debtor Aging data for the selected report date and criteria.
1. Open the standard Debtor Aging Report in AutoCount.
2. Set the required report date and Debtor Aging criteria.
3. Click Export to Excel. If the inquiry result has not been loaded yet, the plugin first runs the normal
Debtor Aging inquiry.
4. When “Where do you want to save the Debtor Aging file?” appears, select the folder and file name.
5. Click Save. The plugin saves the file in .xls format. The default file name starts with “Debtor Agingfor”and includes the company name and report date.
C. Review the Exported Excel File
After the export is completed, AutoCount shows “Debtor Aging file has saved successfully. Do youwant toopen it?”. Choose whether to open the saved workbook immediately.
1. Click Yes to open the Excel file, or No to remain in AutoCount.
2. Review the company name, DEBTORS AGING title and report date at the top of the worksheet.
3. Review the debtor and document details. The export includes account and company details, document
information, total and aging values, and additional debtor information used by the report.
4. The exported rows follow the Debtor Aging report data and its selected debtor and detail sorting.
This is particularly important for businesses that rely on repeat treatment sessions and progress tracking.
Benefits of AutoCount GridToExcel Plugin
Faster Report Preparation
Reduce the time spent manually transferring debtor aging information from AutoCount into Excel.
Better Receivables Analysis
Review exported debtor balances and aging information using Excel’s analysis and filtering capabilities.
Easier Financial Information Sharing
Provide Excel reports to authorized stakeholders without requiring them to open the report directly in AutoCount.
More Consistent Reporting Workflow
Save debtor aging workbooks with relevant company and reporting date information for easier organization and reference.
Conclusion
The AutoCount Grid to Excel Plugin provides a convenient way for businesses to export Debtor Aging Reports directly from AutoCount Accounting into Microsoft Excel.
By preserving relevant debtor information, document details, aging values, and reporting criteria, the plugin helps accounting and credit control teams reduce manual work and improve report accessibility.
For businesses that regularly analyze outstanding customer balances, the Grid to Excel Plugin offers a simple solution for faster and more organized accounts receivable reporting.
Frequently Asked Questions
What reports can the GridToExcel Pluging export?
The documented function supports exporting the standard AutoCount Debtor Aging Report. It should not be assumed to support exporting every AutoCount report or data grid.
What information is included in the exported Excel file?
The workbook contains relevant debtor account details, document information, outstanding balances, aging values, company information, and the selected reporting date.
Does the plugin export document-level aging information?
Yes. The exported Debtor Aging information includes applicable document-level details, allowing businesses to review the transactions contributing to outstanding customer balances.
Does the plugin follow the selected report date and criteria?
Yes. The exported file uses the relevant Debtor Aging report information, including its selected report date, applicable criteria, and sorting.
Can users analyze the exported information in Excel?
Yes. After exporting, users can apply Microsoft Excel features such as filtering, sorting, formulas, and other analysis methods.
Can the exported debtor aging report be shared?
Yes. The saved workbook can be shared with authorized recipients through normal file-sharing methods. Businesses should apply appropriate confidentiality controls when distributing customer financial information.
Start Exporting Your Debtor Aging to Excel Today!
This plugin enables us to export complete Debtor Aging reports directly to Excel with a single click, eliminating manual copying while preserving detailed aging buckets and sort orders. We can efficiently standardize financial workbook archives with automated naming conventions, streamline receivables auditing, and protect data integrity through native AutoCount access control.