A5.29 : How to export Profit & Loss Statement and Balance Sheet Statement to Excel

Question:

Profit & Loss Statement and Balance Sheet Statement do not have Export all data function on grid. Is there any way to export the reports to Excel?

Answer:

Yes, you can preview the report and using the Export To function to export the selected format.

 

For Excel format, you may choose XLS or XLSX to export.

 

After selected the format, the report will be exported, you may click to open it.

--Source from AutoCount Wiki --

• Related Articles

• A5.83 : Accounting - Reports : Profit and Loss Statement

  This function allows you to generate your company Profit and Loss Statement. Profit and Loss Statement is used to show the performance of the company by a certain or specific period. It will be able to show if the company is making profit or loss by ...

• A5.84 : Accounting - Reports : Balance Sheet Statement

  This function allows you to generate your company Balance Sheet. Balance Sheet is used to provide an overview of the company financial status as at specific point of time by outlining the company assets, liabilities and equity. To access Balance ...

• A5.73 : Sales - Reports : Profit & Loss by Document

  This function allows you to generate Profit & Loss by Document report. Profit & Loss by Document report is used to view the profit earned for each transaction. It will calculate by the differences of total selling price against total cost incurred of ...

• UBSA1.116 : Access UBS (Accounting): How to set Balance Sheet report to display This Year profit figure

  EnvironmentAccess UBS (Accounting) Solution To set Balance Sheet report to display This Year profit figure: Go to Housekeeping, General Setup, Setting, tick Display This Year Profit (This Accounting Year Only) checkbox, click OK. Then go to Reports, ...

• UBSA1.135 : Access UBS (Accounting & Inventory): How to generate cost of goods sold in profit and loss by project

  DescriptionHow to generate project reports using the Inventory system and post them to accounts? EnvironmentAccess UBS (Accounting & Inventory) SolutionCOSTING FROM INVENTORY AND BILLING MODULE SELECT COSTING METHOD (Valuation of stock or inventories ...