ROBOTILL HELP

Accounting Software Export

You can export your data for accounting software. Supported accounting software like PiggyZen will import the data without the need to make any changes to the export files.

Data that will be exported

  • Cash sales per type (cash, card and additional payment options).
  • Sales on account.
  • Account payments per type (cash, card and additional payment options).
  • Refunds (cash, card and additional payment options).
  • Inventory purchases.
  • Inventory adjustments (stock take adjustments, discarded stock).
  • Sales tax collected and paid.

It is important that you choose the correct settings before you do the export.

Export Settings

Accounting Settings
  1. The date from where the export must start. This date will automatically be adjusted after each export so that only new data will be exported. You can move the date back again if required.
  2. You can choose between weekly or monthly exports. A file will be created for each month or week depending on your selection.
  3. You can change the export folder if required.
  4. The account in your accounting software that all cash should be allocated to.
  5. The account in your accounting software that card payments are allocated to.
  6. The account in your accounting software that payment option 3 should be allocated to.
  7. The account in your accounting software that payment option 4 should be allocated to.
  8. The account in your accounting software that customer account payments should be allocated to.
  9. The money account in your accounting software used for inventory purchases.
  10. The sales tax you use in ROBOTILL. The sales tax must also be set up in your accounting system with the same abbreviation.

Note that each one of the accounts you specify must be set up in your accounting system. To see how to add an account in your accounting system see: Adding a bank account to your accounting system.

Exporting

To export your data for your accounting system, go to ROBOTILL Back Office > Home > Accounting Export > Export Accounting Data.

Before you export, make sure your settings are correct.

You can export at any time as the export will start where the previous export ended. Files will be created for each period. The current month or week (depending on your frequency selection) will not be included. A list of files that was created will be listed under the export button along with any warning or error messages.

Importing into your accounting system

Once exported, you can import the files into your accounting system. We will use the PiggyZen accounting system for an example.

Log into your PiggyZen account. Go to 'Import' and select 'Import from POS System'.

Import to PiggyZen

You will then be able to select and import one file at a time. If you select the monthly frequency, then you will only need to export and import one file a month. 

For more on accounting see the PiggyZen Accounting Blog.

© ROBOTILL (PTY) LTD - www.robotill.com