nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to generate/export report in excel format from Reckon Accounts hosted

NenethLangley

Comments

Rav

Hi there,
Once you've created the report of your choosing, click on 'Export' in the toolbar immediately above the report.

You'll be presented with the following options -

Click Export.
This will save the file to your Q drive.

If you're using Chrome, Click Download File on your floating toolbar and download the file to a local destination on your PC eg. Desktop, My Documents etc.

You can then open the file using Excel.

Hope that helps

Cheers
Rav

Satwant

Can you change the formulas on the report? Presently if I copy the report the Total Columns and Rows do not work.

Acctd4

@Satwant Yes, the report is fully editable in Excel 😁

Satwant

Partly answered. I want my reports in Excel not have the round formula but plain sum. Thanks.

Acctd4

As mentioned, the formulas are editable but are automatically embedded in the export so will need to be manually changed in Excel.

Satwant

I want my reports in Excel not have the round formula but plain sum. This is a real problem - when I copy a report imported from Reckon to Excel to another file or another sheet in the same spreadshsheet, the formulas do not work. The problem is they keep the link to the original imported sheet. Very tiring to change formula each time and source of making errors. Thanks.

Reckon Accounts Hosted Announcements & Important Info

Check out the latest important info & announcements for Reckon Accounts Hosted

Button

View all Reckon software categories 🗃️

Each Reckon software has its own dedicated category on the Community. Click below to browse all categories.

Explore all categories