What if you don't integrate with my accounting software? - Generic Accounting Export


What is it doing?

Do we not have a direct integration with your accounting software yet? No problem, we have the perfect solution built for you!

Why should I use it?

Save time on double-entry of invoices.
Our clients are saving a LOT of time by utilizing the accounting options-
Check out some more success stories here!

HOW TO - Setting it up / Step by Step
  1. Go to "Settings" > "Company information"
  2. On the right side under "accounting", select "Generic Accounting" from the drop-down list.
  3. Don't forget to hit "Save"!


Now that we told MarketMan which type of export to use,
It's time to specify where the invoices will go - let's set up the suppliers (so the invoices are directed to the correct supplier / vendor in your accounting software) and the categories (so the expenses show up on the correct part of the PNL, even if you buy alcohol and food on the same invoice!)

  1. Go to your accounting software and export to Excel / csv format:
    - The list of suppliers / vendor names 
    - The list of expense accounts
  2. Go to "Suppliers" > "Suppliers"
  3. Click on a supplier name to open the supplier pop-up and scroll down to the "accounting" part
    We now see new fields available for credit account, expense account, tax account (and class, if applicable) 
    If you do not see these fields, please log out and log back in- sometimes it takes a new login to apply the new selection of accounting export.

  4. In the Excel sheet you exported, search for the supplier name, copy this text and paste it into "Credit account"
  5. In the "Default expense account" we'll put the name of the expense account for the majority of your items from this supplier (in case there's more than one)
    Don't worry- we're going to control everything a lot closer with the categories mapping, on the next step. Search the other Excel sheet for the name of that expense account, copy and paste it into "default expense account".
    Don't forget to hit "Save"!

  6. Go to "Suppleirs" > "Categories" and click on a category name to edit this category.
  7. From the Excel sheet, copy the name of the relevant expense account for each category.
    Don't forget to hit "Save"!
HOW TO - Exporting / Step by Step
  1. Go to "Accounting" > "Invoices"
  2. Use the select-all on the top left, or tick the boxes next to the invoices you want to export
  3. Click on "Actions" > "Generic - Excel"
  4. Now you can use the excel to format, manipulate, and import into your system!
Mastering this feature Setting up accounting for a chain with HQ

If you are part of a multi-location you can do this in two ways, depends on the way your accounting is set.

  • If you're using one account for all locations - set this in the HQ
  • If every location (or some locations) have a separate accounting software, you'll need to set this up for each location separately.


Extra tips - from the experts!
  •  You can utilize the sorting option on the "Accounting" > "Invoices" screen in order to export quickly.
    For example: if you want to use the "select all" but only want to export one specific supplier, or one specific week, you should select that supplier and sort to view only the specific dates you want.
    Then use the "select all" on the top left, and export.
    2-3 clicks instead of many clicks to select all invoices!
Was this article helpful?
0 out of 0 found this helpful