Sales (order) data and Sales Tax initial data import fails

Sales (order) data and Sales Tax initial data import fails

Post by S2lzaGJhdW » Sun, 25 Feb 2007 10:11:03


* To remit Sales Tax I must first capture Sales data on a per transaction basis
* Sales transactions are gathered by Yahoo Merchant Solutions and exported
to an Excel
* Import to Accounting Professional is achieved via File > Utilities > Import
* Source file is Excel 2003. Columns have column titles in row 1, data in
rows 2...n

* STOP! NO TARGET TABLE. I cannot import individual Sales data.
Destination choices are these:
- Accounts
- Customers
- Vendors
- Employees
- Service Items
- Inventory Items
- Non-Inventory items

Was this software ever beta tested?

--
MARK KISHBAUGH
Business-Technology Risk Governance and Regulatory Compliance
XXXX@XXXXX.COM
 
 
 

1. INITIAL SALES AND SALES TAX ORDER DATA LOAD PROBLEM

2. Offsetting sales tax on purchases with sales tax on sales

I have correctly set up GST (sales tax) on invoicing, and it records a sales
tax liability. However, the amount owed to the government, which is a
quarterly reconciliation, takes into account sales tax PAID on purchases.

At present, I have recorded this in an account called Sales Tax Receivable,
but I cannot find a way to offset this with sales tax payable to find out
what I need to pay (or have due) at the end of each quarter?

3. Sales Tax on Purchases to Offset Sales Tax on Sales

4. Best Super property sale site for you......sale...sale...sale...sale...sale...sale...

5. Sales Tax Expense vs. Sales Tax Payable

6. backing sales tax out of a total including sales tax

7. Sales Order to Sales History Data

8. Linking Sales Order to Sales History Data

9. Deletion of Sales order and Sales order line

10. Sales Tax Data

11. formula to calculate sales tax from total sales

12. copy sales volume data from sheet 2 to sheet 1 by sales person

13. Service Orders and Sales Tax

14. Add Order Total, Plus Freight, then calculate Sales Tax

15. Tax is regulated on sales order ID XXXXXXXXXX