These instructions will help users with emailing banking file and other reports that can be emailed and steps to copy excel/csv data onto your local machine.



TABLE OF CONTENTS



Emailing Banking File



When processing creditor payments, within online banking file creation screen; Email Banking File (1) can be ticked and enter email address (2), then click on Create File (3)





 

 


Emailing Reports


There are multiple reports that can be emailed from SAM. 

A quick guide on how users can email reports.
  • When the report preview screen opens, click on the PDF button (1) followed by the email PDF check box (2) and add recipients email address (3) then click OK (4)


 





Some of the frequently used reports used as part of the month end or year-end rollover could be: -


  • Debtors Aged Trial Balance
    • This is an ‘as at’ report, can be found in Reports > Debtors,
      Historical ATB’s can be found under Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us)

  • Creditors Aged Trial Balance
    • This is an ‘as at’ report, can be found in Reports > Creditors,
      Historical ATB’s can be found under Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us) 

  • Profit and Loss (Statement of Financial Performance) 
    • You can run this for any period from Reports > General Ledger

  • Balance Sheet (Statement of Financial Position) 
    • You can run this for any period from Reports > General Ledger

  • Stock Valuation
    • This is an ‘as at’ report, can be found in Reports> Stock Valuation,
      historical valuations can be found under Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us)

  • Work in Progress Valuation
    • This is an ‘as at’ report, can be found in Reports> Work in Progress Valuation,
      historical valuations can be found under Enquiry > Archived Reports > select the relevant month folder and report (You can request this report from us) 
  • Trail Balance Detailed / Summary
    • You can run this for any period from Reports > General Ledger.


 Copying Excel/CSV Data

There are multiple reports that can be generated in excel/csv, below is a quick guide to help copy Excel/CSV data onto your local machine.


Reports with option to create MS Excel File / Export to excel can be generated and opened in Libre office from within SAM.
  • Tick Create MS Excel File (1) and click on Print (2)



     


  • Once the excel file path options comes up click on Yes (3)





  • Once the libre file opens, select all data by pressing CTRL+A on your keyboard (also can be highlighted using your mouse by left clicking) and then CTRL+C to copy (also can right click your mouse and click copy)

  • Open Excel on your local machine, press CTRL+V (also can right click your mouse and click paste).       


 Some of the frequently used reports that can be generated in this way are as follows: -


  • Trail Balance Detailed / Summary (Reports > General Ledger) 
  • Purchase Order Listing (Reports> Workshop)
  • Labour Hours Summary (Reports> Workshop)
  • Debtors Aged Trial Balance (Reports > Debtors)
  • Creditor Aged Trial Balance (Reports > Creditors)
  • Statement of Financial Performance; Profit & Loss (Reports > General Ledger) 
  • Statement of Financial Position; Balance Sheet (Reports > General Ledger) 


Requesting Other Files

We can send you files you are not able to access E.g. Reports saved within archived folder.
Please email us at samsupport@sam.co.nz with any files you would like us to send you. We will then send the files through OneDrive and separately send you the password to access the files.