Is there a way to import invoices from an Excel file or other file format?
We have literally 1,000's of invoices to input and want to avoid doing it manually if at all possible.
Also, if this is possible, are there conversion utilities out there somewhere to do this?
Thanks!
You need to create an IIF file.
IIF File - http://support.quickbooks.intuit.com/support/Pages/KnowledgeBaseArticle/1...
Hope this helps. If so please mark solved, if not please ask more questions. Thanks!
Thank you for the link to the IIF file info! Will look at some sample files and get going on that - have done that type of file formatting before (as part of work).
Was looking at the list on that link under "Transactions that can be imported using IFF files:" and came up with a related question: We have various forms of sales that we need to enter daily invoices, for example some are from Amazon sales - which would be daily sales, the payment goes to Amazon, they scrape out their fees, then every couple of weeks they deposit the funds in our bank account.
These types of sales would be under a general customer, for example "Amazon-Sales-Customer" (or similar) as individual customer information is already available on Amazon and is rarely needed anyway.
So thinking if the best method would be to import invoices via the IFF method grouped by date for each day's sales, then enter the payment for invoices using the date that their deposit actually hits our bank account. Am assuming that would be a manual process (not so bad, about 26 payments for the calendar year).
May have to figure out where to enter their fees (which would be as an expense) during that process. Will have to just get in there and try it out.
Will also check if there is a utility that does the above already as that may be a common need for QB users that sell on Amazon, etc.
Thank you and will post progress to this post!
I have the same problem with the fees on credit card payments. Here's what I do:
In receive payments, enter the total amount of the invoice. This zeros out the invoice. Then when I make the deposit, I enter a second line deducting the fees and posting it to the expense account.
I just tried your approach to recording the credit card fees and I just love the way this works. I would recommend this procedure to everyone.
Have been researching this more and came up with some other ideas, briefly:
1.) create bank accounts for each payment source, ie: Amazon-Bank, Paypal-Bank, etc...
2.) download the sales history from those sources, and save into an Excel file...
3.) edit that file to create the IIF format (see ray's post above) as "Cash Sales" depositing the funds into the payment source bank accounts (Amazon-Bank, etc.), save as a CVS file with an .IIF format
4.) then import that file into Quickbooks - these will now show as paid, so the Receive Payments step is avoided, and then when the payment sources actually deposit the funds to your bank account just do the Transfer Funds from source-bank to your bank account using the actual deposit date!
NOTE: still need to workout the fees part so will refer to the post about applying the fees method to incorporate that into the above - good advice!
If this sounds ok or anyone does something the same/similar please share 8^)
There are some commercial products out there that do this I think, however it's too bad that Amazon, Paypal, etc., don't just offer something to export their data directly to IIF format (right?)...
I also enter the credit card fees as an item (with the amount entered as negative) as a line item on the Deposit.
This utility is designed for importing credit card charges and it's easy-to-use and inexpensive: http://community.intuit.com/po...
The source code is available, so you can also customize it to suit your needs.
Check out Transaction Pro Importer for importing invoices, dozens of options available....
Read more on the Intuit Marketplace at http://marketplace.intuit.com/AppID-2681-Overview.aspx
