 As a Strategic Partner, I provided the answers that were published in the Free Weekly Newsletter. Be sure to sign up by Clicking Here. Ask the Expert - PayCycle Integration Issue 4.16 - April 26, 2004 Q - I am using QuickBooks Online for my bookkeeping and PayCycle for my payroll as recommended by Intuit. PayCycle keeps track of all the payroll taxes I pay. My questions are: 1) Do I need do double book the payroll expenses for every paycheck in QBOL when they are already in PayCycle? 2) Is there a way to have PayCycle automatically enter the amounts in QBOL (this may be a question for PayCycle) THANKS!!! A - In answer to the first question: No you do not need to "double book the payroll" when using PayCycle. There is an easy way to integrate the information you already have in PayCycle to your QuickBooks Online file. The first step is to establish the connection of your PayCycle account to your QuickBooks Online file; this is accomplished by choosing 'Online Edition' as your general ledger accounts. This set-up can be found under Account>Preferences in Paycycle. If you have not already set up payroll accounts in your Online Edition, PayCycle will set them up for you the first time you export your data; it's that easy! For the second part, you can contact PayCycle if you want, but, when you export your data, with just one click in PayCycle, all the amounts and details will be sent and posted into your Online account. For step by step instructions, PayCycle has provided this pdf complete with screen shots of the process. Submitted by Todd. Full article Bonnie offers an extensive knowledgebase, to learn more or to join, Click Here. Ask the Expert - Yahoo Store and Version 2003 The "Yahoo Store - Auto Tax Fix" Issue 2.30 - August 5, 2003 Q - I run a Yahoo store and have been using QuickBooks for years for my accounting needs. I recently upgraded to QuickBooks' Version 2003 and all the sudden it will not import my orders and I am getting a lot of error messages. Do you have any suggestions? A - As you mentioned, all earlier versions will import your orders fine....all the way back to Version 99; however in 2003 a new 'glitch' appeared. Below are the procedures to fix the the problem with getting your Yahoo information into QuickBooks 2003 and Higher. While nothing on the surface seemed to change between versions, this is something new hard-keyed in the versions 2003 and higher. The fix is simple, even though it was very hard to find....I would like to thank Don from YStoreTools and Tim from Big Red Consulting for helping track this down! In QuickBooks 2003 and higher, find the “Auto Tax” item -- It is located in your Item List, near the top. By Default it becomes a Service item, which previously caused no importing issues - however newer versions of QuickBooks will check for that Item, find it, choke, and will not proceed with the import. Find that item and either: 1) Delete it - if you are starting out fresh OR 2) Rename it “Auto Tax Old” if its in use. NEXT: Here's the key..... manually create a new sales tax item called “Auto Tax” ....it must be a New Sales Tax ITEM and linked to your state comptroller account. It must be exact - Auto Tax. Now when you import your files it will "see" your new auto tax Item (near the bottom of your list) and your orders will import. If you already have orders in QuickBooks and you go back to revise them for some reason, you will get a message saying that you have an incorrect tax type associated with that order. You need to go the tax box on the bottom of the Invoice, click the drop-down box, and select your new Auto Tax Item and everything will be fine. You do NOT have to update any orders that are already in unless you are making some other type of change to it. This should take care of your error message, allowing you to download your orders and import without any problems.* *Except for the other 'issues' that come along with the .iif export/import from Yahoo to QuickBooks* Ask the Expert - Online Store Credits Issue 2.36 - September 22, 2003 Q - I do not know how to issue credits/returns in my QuickBooks. I know how to do it thru the on-line store manager; but now I need to reconcile my bank and merchant statements. I haven't been doing anything with returns other than entering one reduction in order to reconcile my monthly statements. I can see where I can use the credit memo function but I don't see it in undeposited funds or in my bank account. How do I use it to reconcile? A - To issue a credit in QuickBooks, create a credit memo (Customers > Credit Memo). Enter the customer name. To make reconciliation easier later, it is recommended that the credit memo number be changed to match the order number. For example, if the order was 100, the credit memo would be CM100 or 100-1. Keep in mind, however, that if you use QuickBooks for invoices, the credit memo and invoice numbers are sequential based on the last number on the most recent form that was entered. I.e. in our example, the next invoice number would be CM100-2 or 100-2 by default and will need to be overridden to restore the credit numbering sequence. Enter the items that the customer is returning (this will return the merchandise to inventory when the credit memo form is recorded). If a restocking fee is charged, set up an item if one does not already exist as an Other Charge type of item and the account of restocking fees (an income type account). Be sure to check the total as compared to the actual credit back to the customers account. If the amount does not match, check sales tax to ensure that it is not over or under stated. DO NOT CLOSE THE CREDIT MEMO. Once the credit memo is complete and the amount is correct that you want to refund, click the button at the top of the form that says "Check Refund." This will automatically create a check, with the customer information and amount from the credit memo. You can change the bank account at the top of the form if the amount is refunded through PayPal or a different checking account. Confirm the "To be printed" box is unchecked. It is possible to simply delete any check number that appears. However, it is recommended that the check number reference the transaction. In our on-going example, it could be V100 or 100-2 if it was a VISA transaction to make it easier to match with the VISA merchant statement. At a glance it is easy to see the original sale as 100, the return as CM100 and the refund as V100. Save and close the check. Note: The credit memo is still open and will now be visible. The balance on the credit memo will now be zero. Save and close the credit memo. The above procedure will increase inventory for the returned merchandise, remove the funds from the bank account (when reconciling note that there may be a deposit on the statement that is net of a deposit in QuickBooks and the check created above), and the customer reports will be complete and accurate for all activity. Yahoo Stores and the interface with QuickBooks. For a FREE weekly newsletter of QuickBooks tips and tricks, plus many free and low cost QuickBooks resources, please Click Here |
|