cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Contributor *

importing an excel file into Quickbooks desktop

I use a ticketing software that produces a general ledger summary for me to post to Quickbooks, that contains debits/credits to asset, liability, income and tax accounts. I can export the entry to an excel file or CSV, but cannot figure out how to import the file into Quickbooks.  It keeps coming up with having to create a map, which I don't understand at all.

Anyone have any suggestions?

Thanks

3 Comments
BRC
Established Community Backer ***

Re: importing an excel file into Quickbooks desktop

QB will import your Journals once converted to an IIF file. 

Use our BRC IIF Transaction Creator Pro   to convert an Excel worksheet containing transactions (of many types) to an IIF file for import into your QuickBooks company file.

Community Contributor *

Re: importing an excel file into Quickbooks desktop

Thanks for the reply.  Is this purchase and converting to IIF file, the only solution?  My ticketing program is telling me that you can import an excel file to Quickbooks.  I'd rather not have to make a purchase at this point.

Established Community Backer ***

Re: importing an excel file into Quickbooks desktop


@BRC wrote:

QB will import your Journals once converted to an IIF file. 

Use our BRC IIF Transaction Creator Pro   to convert an Excel worksheet containing transactions (of many types) to an IIF file for import into your QuickBooks company file.


are you allowed to sell your products or offer your services for a fee here?