Accounting file (General)
Introduction
Sharefox has the functionality to export all orders created within a given date range to an Excel file that can be later imported into accounting. This export file will help make accounting of rental orders in Sharefox easier for business owners. The exported file will contain all orders created, and indicate if an order is paid or not.
Through setup in the accounting system the user can determine how the accounting should be done. The setup will indicate which income accounts to use for a sale, how to post VAT transactions and where to post payments. It is important to set this up together with your accountant before starting to use this functionality.
After an order is created in the accounting system, including its payment, the payment can be matched with the transaction report from Nets, Stripe, etc.
Creating the accounting file
The file can be created from the Reports menu in the Sharefox Administration application. The user selectsa date range and can choose to include orders paid with an invoice (Faktura) or not. To create the general accounting file select "General" under the Type field.
Parameters
Start Date: The date from which orders are selected. All orders created on this date an onwards to the End Date is included in the result
End Date: The last date of creation of orders to select. All orders created up to and including this date is included in the result
Include Orders With Paymentmethod Faktura: The user can choose to include orders paid through invoice. As it is possible to create invoices through our invoicing integration partners (Tripletex, PowerOffice and more) for orders with payment method Faktura from Sharefox these orders might already exist in the accounting system. Such ordersshould be exluded to avoid double entries for the same order. The defaulf value for this parameter is off.
Setup and important notes related to data mapping
A number of mappings are available in order to facilitate importing of accounting file data into your accounting system or other accounting processing. This setup should ideally be done together with the accountant for optimal preparation of the data.
Please setup your product mapping and payment method mapping according to this help article.
Other considerations
Change orders in Sharefox
It is possible to do updates, change and deletion of orders in Sharefox. Any such change will trigger a change order, meaning a new order, connected to the original one, with the change. In the case of adding a product to an order, or changing the rental time of an order, the change order will contain the difference between the new order amount and the old.
Example: Extending a 1000 NOK order with one day, adding a 100NOK cost. A change order will be created with an order amount of 100NOK, and the total order amount summed up on the original order and the change order is 1100 NOK.
Each change order from Sharefox will be reported as a new, separate order in the accounting file. The original order and a change order can be connected through the Booking Reference value. This reference allows users to look up the original order in Sharefox, and to easily find the connected orders.
The same system is in place when an order is canceled or deleted. The original order is never deleted, but a new change order with the same order amount using the oposite sign will be created. The total of these two orders will be zero.
Unpaid or partly paid orders
Orders that are partly paid or not paid in Sharefox will be exported into the accounting file as long as the order creation date is within the date range selected when creating the file. The orders will have a payment amount on them indicating the payments done, if any.
Usually, all orders processed through the online payment gateways Nets, Stripe, etc. will be already fully paid.
Orders that are not paid directly via Sharefox, such as Admin orders created with payment method Kasse or Invoice will have to be handled as such by an accountant when/if any payment is received.