If you created a live real time connected Excel sheet or Pivot Table you only need to click the button “Refresh Data” and the XL Reporting Service will retrieve all current data.
If you applied formatting to your data prior, it will still be preserved. No need to re-format your reports repeatedly.
If parameters were defined in the report object, clicking the “Refresh Parameter” button will ask you to enter new input parameters.
Clicking the “Refresh Fields” button will refresh with the most recent field definition of the underlying query.
Manage all accounting transactions
Prepare budget forecasts
Publish financial statements in time
Handle monthly, quarterly and annual closings
Reconcile accounts payable and receivable
Ensure timely bank payments
Compute taxes and prepare tax returns
Manage balance sheets and profit/loss statements
Report on the company’s financial health and liquidity
Audit financial transactions and documents
Reinforce financial data confidentiality and conduct database backups when necessary
Comply with financial policies and regulations