Download
export from myob manual input n.
Skip this Video
Loading SlideShow in 5 Seconds..
Export FROM MYOB Manual input PowerPoint Presentation
Download Presentation
Export FROM MYOB Manual input

Export FROM MYOB Manual input

111 Views Download Presentation
Download Presentation

Export FROM MYOB Manual input

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Export FROM MYOBManual input

  2. Invoice entered manually Total looks good, Discount looks good. Tax is ok.

  3. This price looks good. Affordable on Elizabeth Affordable on Elizabeth 4 Elizabeth St. KENILWORTH QLD. 4574 00012760 23/11/2011 P 0010793573529244 1 Xtr-thk Socks Size 4-6 Blue $6.35$6.99 0% $6.35 $6.99 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.64 $0.00 GST $0.00 $0.00 $0.00 I 5 1 30 0 0 $0.00 Location1 *None 1013 Affordable on Elizabeth Affordable on Elizabeth 4 Elizabeth St. KENILWORTH QLD. 4574 00012760 23/11/2011 P 0020793573590367 1 Xtr-thk Socks Size 4-6 Navy $6.35$6.98 0% $6.35 $6.98 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.63 $0.00 GST $0.00 $0.00 $0.00 I 5 1 30 0 0 $0.00 Location1 *None 1013 Affordable on Elizabeth Affordable on Elizabeth 4 Elizabeth St. KENILWORTH QLD. 4574 00012760 23/11/2011 P 0040793573529251 10 Xtr-thk Socks Size 4-6 Choc $6.35 $6.985 0% $63.50 $69.85 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $6.35 $0.00 GST $0.00 $0.00 $0.00 I 5 1 30 0 0 $0.00 Location1 *None 1013 Affordable on Elizabeth Affordable on Elizabeth 4 Elizabeth St. KENILWORTH QLD. 4574 00012760 23/11/2011 P 0001% online ordering discount -0.01 1% online ordering discount $76.20 $84.00 0% -$0.76 -$0.84 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 -$0.08 $0.00 GST $0.00 $0.00 $0.00 I 5 1 30 0 0 $0.00 *None 1013 Why this price is 6.98 when actually it is the same article as above. With a 10% tax. Why this price is 6.985 when actually the tax is 10% GST = 10%

  4. Export FROM MYOBInvoice CSV import

  5. Invoice imported from csv. Total looks good, Discount looks good. Tax is WRONG.

  6. 1 Ext Thick Blue - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Navy - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Black - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Choc - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Green - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Slate - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Red - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Khaki - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick White - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick Purple - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick W'melon - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 1 Ext Thick HV Lemon - M 4-6; W 6-8 $6.35 $6.985 0% $6.35 $6.985 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 $0.635 -0.01 1% online ordering discount $76.2 $83.82 0% -$0.76 -$0.84 Sale; Affordable on Elizabeth COMPANY SALES GST $0.00 -$0.08 Prices are the same for 12 articles. $6.985, tax is $0.635 0.635*12-0.84 = 6.780 6.985*12 = 83.82 6.35*12 = 76.20 Why is it wrongly imported?