Get answers to those hard-to-solve QuickBooks questions! Chuck Vigeant from ACCOUNTiGRATE LP will be here to answer your toughest QuickBooks questions! Talk to one person you can trust to help you with your accounting, QuickBooks setup and usage, custom reports, ODBC, SDK, and data integration questions. Tap into Chuck's real world experience working with QuickBooks users like you.
***This event is closed. You will not be able to ask questions but you can still read the posts.
One thing I didn't see was how the item was being paid (are you cutting
a company check, is this a combination of company petty cash and his
cash?)
Do you reimburse the partner when you received the money?
In
simple terms, you just need to track each transaction - and each piece
of it. So if partner monies are going in and out they need to be
recorded in a partner draw account so your accountant can make the
appropriate year end journal entries.
Hi Chuck, I have a Promotional Advertising company. I do not inventory
any products at all. I rep several thousand different vendorsthat sell
Pens, watches, shirts, jackets, calculatores,etc, etc. I send my
clients logo and the vendor then imprints that logo on their product
and they ship directly to my client.. The factory then invoices me and
I invoice my client. I just purchased the Pro2008 Quickbooks software
and I do not see that it can be cujstomized for this industry. Please
advise. thanks, Cheryl Freeman/ Freeman & Associates, Inc.
From what I am understanding, you are just acting as an intermediary,
so the "items" never hit your floor as inventory. In the simplest form,
you would just create bills and invoices..
Obviously you want
be able to run inventory related reports, since the transactions never
hit inventory. You can however, create reports to show sales quantities
that could be manipulated in Excel, etc.
I would consider
contacting a certified pro advisor who can talk a little more in depth
with you regarding your specific reporting and operational needs. I am
not doing you justice here.
I am new to quickbooks inventory, i pulled up the active inventory
today and there are three pages of negative amounts on hand. How do I
get rid of the negative amounts? I do not want to change any balances
on my balance sheet when I make any inventory adjustments.
I am looking to create a Crystal Report to include some of the user
defined fields in Quick Books. The qodbc connection is REALLY slow, so
I am wondering if there is a way to install the report into the Quick
Books repository and will this make the report run faster.
I am not sure what you mean by the QuickBooks repository...
The
QODBC uses the SDK (Software Development Kit) to extract data from
QuickBooks. The SDK uses XML as the extraction mechanism - not a direct
SQL connection to the database - for security and data organization
purposes.
So on larger files the extraction process can be
quite slow. What the folks at QODBC did was to create a caching
mechanism which works like this:
The cache is actually a
separate encrypted database which sits on the desktop. The initial data
load from QuickBooks fills up the cache with all current information.
This can take anywhere from 15 minutes on a sample company to several
days for files of 1 Gig or more.
I know this sounds scary, but
realize any subsequent requests for data using the QODBC driver will
just get data updates - so your information is current. The result is
that your report will run in a matter of seconds.
Bottom line,
the initial load of data can be quite painful, but things move along
quite well after that. You will also need to set the ODBC setup panel
to use these two options (on the Optimizer Tab): Keep my optimized data
up to date as of "The start of every new connection"; and check
"Multi-table Sync". Without these options checked your Crystal Report
will never be quick.
WHEN I DID THE INTERVIEW QUESTIONS TO START QUICK BOOKS I OPENED BANK
ACCOUNT BUT DID NOY ENTER BALANCE, NOW I WANT TO RECONCILE BANK
ACCOUNT.I HAVE TRIED TO EDIT AND CANNOT.PLEASE HELP.
You can go the bank account register and enter all outstanding items -
and offset to Opening Balance Equity. You must be careful here, because
the total balance showing for your bank account ledger must match what
your accountant shows in the Trial Balance.
We use Quickbooks Online so not sure
which version it is. My question is this....is there a quick way to
un-reconcile a bank statement, other than doing each line-by-line
manually?
We are a non profit 501(c)3 corporation using employees with handicaps.
Employees are paid via production and we need a report to show us when
their production pay falls below minimum wage or guaranteed rate. We
also need a report that tracks the average rate on each individual. We
do payroll in house using Quick Books enhanced payroll. How can we get
these two reports?
Thanks,
Ron
Well there is no canned report to get this, but outside of creating
something like this with Crystal Reports, I wanted to point out where
you might get this information so you could manipulate in Excel.
In
the Custom Trasnaction Detail Report: filter by transaction type =
Paycheck; filter by payroll items = All Earnings. For the columns make
sure you choose Sales Price (which is actually the rate at which an
employee is paid), Qty (e.g. representing hours), and the Amount - and
any other columns you want.
Happy Holidays! Go to accountant.intuit.com and look for the pro
advisor section on the left hand side... it will give you all of the
information you need to enroll in the program and become certified.
We closed our business for two weeks and no payroll was issued. How do
I clear the payroll screen of the scheduled payrolls which were not and
will not be issued? THANKS!
I need to track vacation time in
payroll. Everyone is on salary and it doesn't seem to work well with
the vacation being hourly. What is the best way to set up payroll and
track vacation when employees are salary?
