Import CSV in QB Desktop
Want to import lots of highly repetitive 3rd party bill info into QB where only two piece of information change from bill-to-bill
Think of a recurring subscription where the vendor & amount is always the same - but the date and invoice number change (internet bill, cellphone bill, or perhaps even something that is billed multiple times per day). Creating an Excel spreadsheet is simple and far faster than entering data manually one bill-at-a-time in QB, especially if dealing with many hundreds of days of bills.
If there is a way to do this, then I can get a team of 10 people to deal with a huge backlog of thousands of only-on-paper data that is then imported in large batches into QB.
A sample comma separated file for a hypothetical "ACE Machinery" vendor might have the following sort of data
Date Invoice # Vendor Amount Tax Total Notes
20051201 1907365 ACE Machinery $100.00 $8.00 $108.00 ring gear
20051201 1097388 ACE Machinery $120.00 $9.60 $129.60 thrust bearing
and so on
and so on
Is there a QB routine that specifies field order to a comma separated value import?
Are there any tricks to this?
Thanks