You can archive orders in MyCashflow, which means that their contents will be locked for bookkeeping purposes. Archived orders are the basis of the bookkeeping report, which contains a comprehensive breakdown of sales with regards to taxation and accounting.
The point of archiving is to make sure that the online store's reports also remain reliable in the long run. No changes can be made to the contents, amounts or payment transactions of archived orders, which means that archived orders always appear in reports for the same time period.
Basic information about archiving
The following changes that would have impact on bookkeeping cannot be made after an order has been archived:
- Adding new products
- Deleting products
- Editing quantities
- Editing product unit prices
- Editing tax rates
- Editing shipping and payment costs as well as discounts
- Refunds or other changes to payment transactions
Often, editing customer information may impact an order's VAT rate (depending upon the order's delivery destination, and on tax-free EU community sales). However, changes made to customer information don't impact tax rates and totals in archived orders.
Canceled orders cannot be archived, and archived orders cannot be canceled.
Enabling order archiving
To enable manual archiving, follow these steps:
- Go to .
- Press Archive settings. on item
Now you have enabled manual archiving of orders in your online store. Orders can now be archived by all users who have access to thepage.
Next, grant bookkeeping permissions to all necessary users of the admin panel. With bookkeeping permissions users can undo archiving or set the date of archiving (by default this is the day when the order has been archived).
You can manage user permissions in the settings of each user account on thepage.
Archiving orders manually
You can learn here how to archive orders manually.
At the end of every month, you may want to go through orders that haven't yet been archived and archive them before sending the bookkeeping report to your bookkeeper.
The order will become visible in the bookkeeping report immediately after archiving.
Archiving orders automatically
Orders can be automatically archived either when they are received or when their products are marked as delivered. Alternatively, you can manually archive orders.
When enabling archiving, notify the MyCashflow customer service of your preferred method for archiving orders.
Processing returns and exchanges for archived orders
You can process returns and exchanges even for orders that have already been archived. In such a case, the archived order will remain untouched and a new return order will be created in your online store to account for the changes.
- On the admin panel's , search for and open the desired order. page
To search for archived orders use the search tool in the right-hand pane on thepage.
- In the shipment table, mark all products that need to be returned or exchanged.
- In the heading row of the shipment table, click .
The return form opens.
- In the return form, define the return settings.
See also the description of return settings.
- In the return form, click .
A new return order is created in the online store to which you will be redirected.
In the case of exchanges, products that should be exchanged will be displayed as a separate shipment.
- In the return order's shipment table, click .
The return order is marked as having been delivered.
- If you need to make a refund to the customer due to a return, in the return order's Payment transactions menu, click .
- Finish processing the refund.
- Exchanges: Mark the potential products to be shipped as delivered once the customer has made the relevant payments.
- If order archiving is enabled in your online store, archive the order to bookkeeping once you're sure that you will no longer have to edit it.
Your online store's archived orders are accounted for in bookkeeping reports, with a comprehensive breakdown of sales with regards to taxation and bookkeeping. You can learn more here about the report's different sections.
To access the report, in the admin panel go to.
The report can be generated for the time period of your choice. In the report, you can see the turnover excluding VAT, tax amounts, and sales including taxes.
Order values accounted for in the report are those values which are set at the moment at which archiving is carried out. Changes made before an order was archived aren't accounted for in the report. To generate a report without order breakdown, select the option Show only summary.
See the attached breakdown for the VAT charged on a country-by-country basis.
Net sales (by tax rates and processing) – Sales discounts (by tax rates) = Net sales in total
Sales of goods outside the Community
This will show you sales including and excluding taxes for a selected time period according to tax rates, as well as tax amounts for every tax rate.
If your online store only has domestic sales, your bookkeeper can use this table to report the turnover by tax rates.
The breakdown by country illustrates country-specific sales according to different tax rates and the amount of taxes.
This breakdown contains information on intra-community orders according to VAT numbers that were archived during the defined time period. The VAT calculations are mostly based on the country of delivery as well as the VAT liability of the customer's EU area.
If the customer is a business that is subjected to value added tax, sales must be processed as EU sales, exclusive of VAT. EU sales which are exclusive of VAT must be reported to tax authorities in monthly tax declarations (including country, VAT number, and sales which are exclusive of tax).
The totals associated with different payment methods are reported in bookkeeping in separate accounts as receivables, from where they are credited once the money has been received (e.g. a settlement has been made by the payment service).
Orders with under- or overcharge
At times, your online store may have orders whose open or completed payments don't match the order total. This may happen if returns or exchanges haven't been duly processed.
So in this section you can see orders for which customers have been overcharged or for which they paid too little. Such payments must be corrected by creating positive or negative payment transactions for the order.
The breakdown of open orders contains a list of orders that haven't been paid for, as well as details such as order status, totals, and the amount to be paid.
The order numbers on the aforementioned lists are links. Click them to easily access orders that require correction.
If necessary, you can undo archiving for an order, which will allow you to edit the order's sums and products and will remove the order from bookkeeping reports.
Make sure to notify your bookkeeper if you undo archiving
If you undo archiving for an order, the order won't be included in bookkeeping reports anymore. Make sure to provide your bookkeeper with an updated report for the month during which the order was originally archived.
If you re-archive the order later on, the order will be displayed in bookkeeping reports with the date of the most recent archiving.
You may want to undo archiving before you settle VAT.
Archiving can be undone only by users who have the Bookkeeping permission. The account owner of the online store can grant bookkeeping permissions to users on the admin panel’s page.
To undo archiving for an order:
- Open the archived order on the admin panel's page.
You can easily find archived orders by using the Archive status filter in the right-hand pane.
- At the top of the order page, click .
After undoing archiving you'll be able to edit the order's products and sums.
If necessary, once you're done editing, re-archive the order and provide your bookkeeper with an updated bookkeeping report.