Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 11-15-2006, 01:18 PM
Trout Trout is offline
Registered User
 
Join Date: Nov 2006
Posts: 3
Can a MS Excell spreadsheet be imported to post employee's time?

Can a MS Excell spreadsheet be imported into QuickBooks, so the employee's timesheets are automatically posted?
Reply With Quote
  #2  
Old 11-15-2006, 03:01 PM
gibbo gibbo is offline
Registered User
 
Join Date: Oct 2001
Location: Australia
Posts: 1,597
The answer is no - not directly. However, I have made an Excel spreadsheet that you can save as an IIF file for import into QuickBooks. It creates the same type of file that is created from the Timer. It is not a fully developed program, just something I played around with last Christmas. But quite a few people have been using it to get time information into QuickBooks. It uses data validation, has drop-down lists and a date-picker. It is freely available for use, but is not to be used as a basis of a commercial product without my permission.
It can be downloaded from http://www.quickbooksgroup.com/?233@...osure=.eefd696
If anyone wants to use it, please feel free, just drop me an email letting me know.
Big Red at http://www.bigredconsulting.com/AboutTimesheet.htm have a commercial product for $49.00 that creates the same IIF files using Excel.
I have been wanting to write an ActiveX that could automate the process to a single click in Excel, but my Partner (who writes the code) will not do this unless we actually have someone to buy it. If you are interested in being able to create the info in Excel and have it automatically imported into QuickBooks - and are prepared to pay $100 for the privilege, email me.
__________________
John Gibson
johngibson at ozbizsolutions.com.au
Reply With Quote
  #3  
Old 11-15-2006, 09:28 PM
Trout Trout is offline
Registered User
 
Join Date: Nov 2006
Posts: 3
Thank you gibbo

Thanks for the advise regarding use of a MS Excel spreadsheet with QuickBooks!
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 10:40 PM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.