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

NenethLangley
NenethLangley Member Posts: 1 ✭
edited March 2018 in Accounts Hosted

Comments

  • Rav
    Rav Administrator, Reckon Staff Posts: 15,092 Community Manager Community Manager
    edited February 2017
    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 -

    image


    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
    Reckon Logo - Signature.png
  • Satwant
    Satwant Member Posts: 10 ✭

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

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,167 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

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

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner(AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Satwant
    Satwant Member Posts: 10 ✭

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

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,167 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert

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

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner(AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    [email protected]

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Satwant
    Satwant Member Posts: 10 ✭

    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.

Categories