You can archive orders in MyCashflow, which means that their contents will be locked for bookkeeping purposes. You can learn more here about archiving orders and bookkeeping reports.
The point of archiving is to make sure that the online store's reports also remain reliable in the long run. Once the order has been archived, its contents, totals, or payment transactions can no longer be changed. In this way the order will always be displayed in bookkeeping reports with the same date.
Archived orders are the basis of bookkeeping reports, with a comprehensive breakdown of sales with regards to taxation and accounting.
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.
- whether you'd like to archive orders manually or automatically (for more information about the two options, keep on reading)
- which users should have bookkeeping permissions.
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.
- Go to the order page.
- In the upper right corner of the order page, click .
If your user account has bookkeeping permissions, you can also specify the date for which the order should be archived.
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 our customer service which method you prefer.
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.
To search for archived orders use the search tool in the right-hand pane on thepage.
- In the heading row of the shipment table, click .
The return form opens.
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 menu, click .
Make sure that your online store has a payment method that can be used for making refunds (e.g. MyCashflow Refund).
- Finish processing the refund.
- Exchanges: Mark the potential products to be shipped as delivered once the customer has made the relevant payments.
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. If you'd like to give the Bookkeeping permission to a user, contact our customer service, e.g. via the chat in the admin panel.
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.