Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Importing from Excel for Purchase Order and General Journal Entries |
Author |
Message |
|
Posted : 2006-09-19 06:28:11 |
I have a basic export file from a custom application that I would like to import to QuickBooks using QODBC to simulate an employee invoicing the company in order to reimburse that employee for out of pocket expenses. The file can be exported from the cutom application in .csv or .xls and has various line items relating to expenses submitted by different employees. ex. "Employee name, Expense Description, GL Account # to Debit, GL Account # to Credit, date, Amount, JodID". I need to Debit various GL accounts listed in each line and Credit the Account Payable GL Account, Payee Employee. i.e. Simulate receipt of an invoice. It is possible that the file contains several line items per employee and also several employees. I only want to create one invoice per employee with all their individual line items totaled so that we can cut one check per employee.
I also need to import a .csv file from the same custom application that can simply do a General Journal entry. Ex. GL Account # to Debit (expense account), GL Account # to Credit("Prepaid credit card account"), Amount, date.
Can anyone help me understand how I can do this with QODBC or point me to a location that will help me? I have looked at the QODBC site but I have little expereince with SQL and I'm not exactly sure where to start. In concept, it seems simple enough: just link to the file with various column headings and map to QB. As a first time user, the QODBC initially seems so confusing as many of the posts have SQL queries. Any help would be much appreciated. Thanks.
Best, Noel |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-09-19 08:52:45 |
Reimbusements are normally done within "Other Payroll Items" within the QuickBooks Payroll System.
Unfortunately, payroll entries are not allowed by Intuit in their qbXML SDK and is therefore not available to QODBC.
The alternative is to treat these reimbusements as Bills, see: How do I create Bills? |
|
|
|
|