You are able to export your bills into MYOB Offline via a TSV/CSV File.
The very first step that needs to be done is to ensure that your Product Categories match your Accounting Code in MYOB.
To view your Account Names’ codes, in your MYOB account, go to Accounts > Accounts List.
You may have several Account Names that are relevant (e.g. Food Purchases, Beverage Purchases, Utilities, Rent, Maintenance.)
In your FoodRazor Account, go to Settings > Product Categories > + Add Product Category > Enter the relevant Account Names (digit codes) into the Name field, then click save (✓).
Go to My Products to assign the Product Category name to each product:-
Go to Reports > Invoice Details
Use the filters to set the date period, location and suppliers.
Click UPDATE when that is done.
Once the report has loaded, select the green icon at the top right of the table - The report will be opened in Google Sheets.
Invoice details report in Google Sheets (Sample):
Sheet 1 will reflect the invoice details report from FoodRazor. You will need to copy the formula provided in the table below to populate the information required for exporting.
Copy the following information into a new Google Sheet (Sheet 2) to populate the information:-
Header for MYOB | Formula (1st Line below Header) | Matched to FoodRazor Report | Note |
Co./Last Name | =Sheet1!B2 | Supplier Name | Ensure that this matches the name in MYOB |
Date | =Sheet1!D2 | Invoice Date | Date format to be dd/mm/yyyy |
Supplier Invoice # | =Sheet1!C2 | Invoice # | - |
Description | =Sheet1!E2 | Product Name | - |
Account # | =Sheet1!M2 | Category | Ensure Category has been set in FoodRazor. Product Category should match code in MYOB. |
Amount | =Sheet1!J2 | Subtotal | Line Item Total before GST |
Inc-Tax amount | =Sheet1!L2 | Total | Line Item inclusive of Tax |
Job | =Sheet1!A2 | Location | Job should match Job number in MYOB. Make the necessary changes. |
Tax Code | =if(Sheet1!K2=0,''N-T'',''G7'') | Tax | Please check the tax code used in MYOB and make the necessary adjustments. Common tax code:- 7% - G7 0% - N-T |
GST Amount | =if(Sheet1!K2=0,'''',Sheet1!K2) | Tax | For GST Amount to be reflected in the bill. |
memo | Optional | N.A | Optional |
AP ACCOUNT | Optional | N.A | Optional |
You can double-check the formula according to the gif provided below to see if it matches the headers.
Once the information has been populated, it should look like this (Sample):-
* A blank line should be added between separate invoices.
NOTE: You will have to take note of the following information in the report for the export.
(i) Account # - ensure all products have a Product Category code assigned to them.
(ii) Supplier Name - match your suppliers’ names within FoodRazor with their corresponding names in your MYOB account.
To view your suppliers’ names in your MYOB account, go to Card File > Cards List.
Copy and paste your suppliers’ name within MYOB into the report under column: SUPPLIER NAME
If the supplier name in FoodRazor is an exact match to your MYOB’s suppliers’ name, this step can be skipped.
**The following is only applicable to you if you have more than one outlet (Job) in your MYOB account.
(iii) Job - match your outlets in FoodRazor with your outlets (Jobs) in MYOB.
To view your Jobs, go to Lists > Jobs.
Copy and paste your Job Name into the column: JOB
If the Job Name in FoodRazor is an exact match to your MYOB’s Job name, this step can be skipped.
(iv) Tax Code - based on the formula, the tax codes have been set to what is normally used in MYOB.
You may check against the Tax Code used in your MYOB and change the formula accordingly.
Once these have been done, download the files from Google Sheets in either of the following formats:-
Import your invoices to your MYOB account
1. Ensure that your PC follows the following date format: DD-MM-YYYY.
2. In MYOB, go to File > Import Data > Purchases > Service Purchases.
3. Use the following default settings*, then click Continue.
*for Import File Format, select according to the format of the file downloaded (CSV / TSV).
4. Select the file that was just downloaded from FoodRazor - Invoice Detail Report.
5. A window should pop up, prompting you to match Import Fields with MYOB Fields.
First, click an Import Field, then click its corresponding MYOB Field.
When you’ve finished matching all the Import Fields, click Import.
6. Another window should pop up, summarizing the invoices (“records”) that were imported.
7. If your records were skipped, or imported with warnings, follow the instructions on your screen to locate the “MYOBLOG” file to find out why.