Set Up to Display DSO in Collections

An administrator with a Company subscription to Cloud Storage needs to create a cloud storage option for exporting financial reports to Auditoria. This is a one-time setup event.

1. First, add Cloud Storage permission to the administrator role.
   Company > Admin > Roles
2. Find the admin role in the list, then click on Subscriptions (on the right side).
3. Find Company, then click on Permissions (on the right side).
4. In the Company Permissions popup, scroll down to find Cloud Storage in the list.
   
   
   
   
5. Select all permissions for Cloud Storage, click Save, and exit the popup.

6. Go to Reports > Setup > More > Cloud storage.
   This opens the Cloud-Storage Targets page.

7. Select the target from the list (if it exists) or add a new one.

8. To add a new one, click Add and fill in the Cloud-Storage Information form.
   Storage type: HTTP
   Under Storage type details:
   Address/URL: https://app.auditoria.ai/api/data-listener/intacct-fin-report
   HTTP user name: Copy the token for your Sage Intacct instance that is connected to Auditoria.
   HTTP Password: Copy the secret key and paste it here.
   To find the token and secret key, see Copying Your Sage Intacct Token and Secret Key.
   
   

   
   

   Financial reports can now be exported from Sage Intacct to Auditoria.

9. Go to Home> Applications > Reports > Financial reports.
10. Select Income Statement > Schedule (on the right side).
11. Set the Reporting period for the previous month.
    You can either set the Reporting period to Prior Month.
    or
    You can create another column with the Reporting period set to Prior Month.
12. Fill in the Schedule Financial Report form.
    For the start date, choose the date when you close the books for the previous month.
    For example, if you close on the 5th of every month:
    Start date: 01/05/2021
    Ending on: Never
    Recurrence: Months
    Every: 1
13. Under Delivery options, select Store in cloud.
14. Select the new cloud storage target you created in step 8.
15. Enter the Report Name as income_statement.
16. Select the Report Type as CSV from the dropdown.
17. Click Save.

Copying Your Sage Intacct Token and Secret Key

1. Log in to Auditoria.
2. Click the gear icon  and select System Settings.
3. Copy the Token and the Secret key for your Sage Intacct instance.
   To copy the secret key, click Copy. You may need to generate a new key.
   You will use these credentials for the user name and password in Sage Intacct.