60 likes | 188 Views
Export FROM MYOB Manual input. Invoice entered manually Total looks good, Discount looks good. Tax is ok. This price looks good.
E N D
Invoice entered manually Total looks good, Discount looks good. Tax is ok.
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%
Invoice imported from csv. Total looks good, Discount looks good. Tax is WRONG.
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?