LinkBack URL
About LinkBacksIs it possible to prepare an excel spreadsheet with bill payment information then upload that to QB Pro to print checks? I know you can export from QB to Excel, but I have never tried to import info.
Thanks!
Can you upload info from Excel to QB Pro?
Is it possible to prepare an excel spreadsheet with bill payment information then upload that to QB Pro to print checks? I know you can export from QB to Excel, but I have never tried to import info.
Thanks!
I know you can import checks, and to have QuickBooks see them for printing just put "To Print" in the check number field. As for importing them as bill payments similar to what you would do through the accounts payable screens I don't think that you can. The matching of bills with their payments is done internally in QuickBooks and that match is an attribute that can't be imported.
You'll need a 3rd party application to do it. Check out www.q2q.us, www.bigredconsulting.com or Transactions Pro from BayState Consulting. Pricey but worth the money...
zahid
Google Plus: +Zahid Lilani | Twitter: @ZahidLilani
“Your time is limited, so don't waste it living someone else's life."
- Steve Jobs
IRS Circular 230 notice: In order to comply with requirements imposed by the IRS, I must inform you that any tax advice contained on this forum is not intended or written to be used, and cannot be used, for the purpose of avoiding penalties under the Internal Revenue Code.
Thanks everyone for quick response...
It might be possible But it need to change format to csv there..Originally Posted by ZahiD
Have a QuickBooks Accounting Software question or problem? Free Accounting Software to other users?
Export Excel in .csv (comma delimited) or space delineated.
Excel 2000; 2003
File > Save as > CSV (comma delimited)
Excel 2007:
Save as > other formats > select comma delineated in format drop down
Import via Import Data regimen. Outlook allows mapping fields (ex.: Customer name and information) with import function in .csv format.
Depending on what you want to import, you may need a custom program to do the importation for you. It's handy and can worth the money if you need to repeat the operation over time.
Hope it helps.
Patrice
www.theqbdeveloper.com - Custom Development Service for QuickBooks
How To Import Excel to MS Accounting Pro 2009
Import Excel to QB or MS Accounting Pro 2009
MS Accounting Pro 2009: File>Import Excel Data
MS Accounting Export to Excel
Last edited by Helse; 05-10-2009 at 05:31 AM.
Import
Yes you can,you first have to export it out excel and then the trick is to get it int the right format for quickbooks able to import it. www.accountantfinder.co.za
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks