Accounting Export
Intro:
The Accounting Export section allows you to get access to detailed CSV files with data that can be filtered for deeper analysis and accounting purposes.
We offer different templates for different needs to improve ease of access to the needed information.
How to access Accounting Export:
From the top navigation menu, you will find the Accounting tab.
When hovering the mouse on top of this option, you'll find the following dropdown menu with the Accounting Export option:
Accounting export page:
Once on the Accounting export page, you will be requested to input the Export Settings for the file you'll want to extract.
From: First date you want to export data from
To: Last date you want to export data from
Field separator: Value used to separate the columns in the file
Decimal separator: Decimal separator in numerical values
Date format: Format of the export date
Template: There are different templates with different usecases that we will describe below
Export templates:
The Template menu on Export Settings page presents the following dropdown menu:
Templates:
A brief description of the different templates available for exporting your data.
Invoices export:
The Invoices export contains essential invoice related information, such as invoice ID, order ID, order date, payment method, shipping cost information, due date and more.
Invoices export (detailed):
Invoices export (detailed) provides detailed information, separated by lines, of each invoice. This means that for each invoice there will be multiple lines, the type column references the different cost type, if it is tax or the total, while the column value contains the numerical value associated.
Creditmemos export:
This export shows the credit memos emitted in the selected time period. Includes the due date, payment method, total value, credit memo ID, date and more relevant information.
Payments export:
Contains payment data related to each order, amount, payment method, date, order ID, order date.
Purchase order export:
A file containing the purchase order details. Column details: supplier, PO reference, supplier reference, received percent, shipping cost, total, subtotal, status, id, date and eta.
Purchase order details export:
This export contains the purchase order information, similar to the previous one, but contains sku and supplier sku values, meaning you have a more detailed view of the products contained in the PO and the percentage of each product received for each PO.
Supplier invoices export:
Supplier invoices export contains the details of the invoices per PO.
Contains the date, due date, accounting date, reference, supplier, type, values including and excluding tax, invoice id and reception count.
Supplier payments export:
Exports a file with the details of payments to suppliers.
Contains invoice date, supplier, currency, amount, method, date, invoice reference and invoice total.
Supplier reception not reconciliated export:
This template exports data of received stock that has not been reconciled.
Contains reception, reception date, supplier, purchase order, reception value and reconciliated value.
Defferred revenue:
Deferred revenue allows to export details of advance payment for products that are to be delivered in the future.
Contains the columns of product name, order id, order status, order date, sku, quatity, supplier, unit shipping and unit sale price.
Orders invoiced but not shipped:
This export generates a file with details of orders invoiced but not yet shipped.
Contains the date, invoice, order id, order date, store, currency, country and total.
Order Line Items:
Order Line Items template generates a file with the status of each order from the selected period.
Contains the order status, order reference, order currency, shipping description, payment method, store siew name, shipping costs, sku, product name, product quantity, unit price, total.
Shippment line items:
This template exports the shippments information.
Contains order status, order reference, shipping description, payment method, store view name, shipping costs, product name and sku, product quantity order and quantity shipped, unit price, tax rate, total, warehouse, discounts.
Custom export:
Custom export is a reserved template for custom needs and requirements. We can provide tailored exports based on your needs.
This may require development from our team.
Sales shippment export:
Exports the file containing the shippment details for each sale.
Contains date, order ID, order date, quantity, weight, shipping method and cost, track number, warehouse and store ID.
Supplier reception export:
A template that includes the information related to supplier reception.
Contains reception date, reference, supplier, delivery progress, product count, details, value and total applied.
Related Articles
Accounting
Accounting option in MyFullfillment allows you to get the details of the overall functions of MyFullfillment. The options in Accounting are: 1) Costs of Goods sold 2) Customer invoice 3) Customer credit memo 4) Pending payments 5) Supplier invoice 6) ...Data Import and Data Export
Data import Navigate to Menu Wizard >> Scroll down to Data Import You will find various import types as below: 1) Products update 2) Product / supplier association 3) Purchase order update 4) Stock and location 5) Suppliers Supplier import You can ...Change .csv file encoding to UTF-8
Boostmyshop app only works with .csv files that are encoded in UTF-8, default export sometimes can give you a file that is similar but encoded in UTF-8-BOM or ANSI. This article will explain how to generate a correct file and how to change the ...Suppliers Export
Suppliers export 1. How to access To access the supplier Export function, simply go into menu : Purchasing >> Suppliers There, you will find located at the top left corner an "Export" button, allowing you to export the suppliers grid data. 2. Process ...Stock export
How works stock export Many integrations (Magento, Shopify, Hiboutik, Prestashop etc....) supports the stock export feed. This feed sends the stock available to the external system. The stock sent is calculated using several parameters : First, only ...