Join us for a "QuickBooks Community Ask the Expert featuring Erin Eckert," of Office Management Solutions. Talk to one person you can trust to help you with your accounting, tax, and QuickBooks questions. Tap into Erin's real world experience working with QuickBooks users like you. Join us for an Ask the Expert event with Erin Eckert.
***This event is closed. You will not be able to ask questions but you can still read the posts.
Not a problem...Click on Banking - then click on Make Deposits - Enter your Deposit To Account - the Date - A Memo -the Received From (I usually leave this blank) - then in the From Account put the expense account you got the rebate from. So if the rebate was for supplies put supplies or if it was for utilities put utitilies. It will show as a credit to your expense (which reduces your expense) and it will show as a debit in your checking account (which is an increase).
Question:
Real Estate and Property Management Aug 05, 2006 09:18 am
Erin,
I am working on setting up a Property Management company. There is one corporation and we have two separate "companies" set up, one for Real Estate Sales and one for Property Management. If they want to write a check from the Property Management company to the Real Estate company would you set up an Equity account for each company in the other to act as a clearing account which would zero out at year end?
Hi Pat - Yep, you got it. I was debating on whether or not an Equity account is the proper type. But I don't think it can hurt anything. Just make sure at the end of the year the acounts balance out between the two companies - if you don't it wil get really messy.
I am not sure what you mean by deleted or stepped on a couple of reports - but you can always recover reports. If they were memorized reports you can go into the Reports - then memorize reports - and pull it back up.
If the reports weren't memorized - recreate the report then memorize it.
If this didn't clear up your question please write back.
Question:
GL Account Numbers on Balance Sheet & Income Stmt Aug 06, 2006 06:21 am
Hi,
Could you please tell me if the Balance Sheet and Income Statement reports can be viewed and printed without the GL Account Numbers showing? I remember in older versions of QB's I've printed them with the name of the GL Account only but in 2006 I don't see the option, it's probably right in front of me.
I have an enquiry. Im currently using Quickbook Pro 2006/2007 - 2 user; Me and my Director. Recently, he has created his own template of sales invoice etc (using his lap-top). He was wondering.. if he were to sent the backup file for me to restore (in my computer), will I able to view the template and at the same time will the new template become my default template (the next time i create any sales invoice-using my computer)?
Here is my understanding of the question - You have a multi user version of QB's Pro 2006. Your Director created a sales invoice and other items on his laptop.
If the laptop was not connected to the server - basically - it works independently; then no it won't work. If you transfer his laptop backup file to your server then it will restore only what is on his laptop to your computer.
If you both have a single user 2006 version on each of your computers independently then no it won't work either. Again - his laptop works independently.
If you two don't have a multi user version of QB's then you will need to create the template on your own computer.
Question:
Certain transactions missing from Reconcile Window Aug 06, 2006 06:45 am
Erin:
I hope you understand how much joy you bring to people when you solve their problems. We are lost in small business limbo without you!
I am finally reconciling my bank statements after a busy start to a new business. All went well the first 3 months. Suddenly in month 4 I am missing 4 AmEx transactions in my Reconcile Window. They exist on my bank statement and in my AmEx statement and most importantly, in my General Journal entries in QB. But they have not made it into the Reconcile Window. So I cant happily check them off! I've checked my dates in the Gen Journal entries. All looks right to me. In fact, they are many similar, "well behaved" AmEx transactions both before and after these missing ones.
I dont know what it signifies, but the missing entries are from 4 sequential dates.
I would hate to make an adjusting entry, since the transactions clearly are already in QB. Not sure how to fix it, please help!!!
I tried to recreate what you described so I could see how or why the General Journal entries wouldn't show up. The ones I recreated showed up - just like all your other transactions. The only suggestion would be to delete the 4 General Journal entries and reenter them.
Another suggestion would be to enter the credit card transactions in Banking then click on Enter Credit Card Transaction. It sounds as if you are entering the charges in as General Journal.
Thanks for writing and the kind words. Good Luck - Erin
I have used the Receive Payment option before, however, it deposits the payment in an account called undeposited funds, then when I select it and make the deposit, it labels it under undeposited funds in the deposit screen. We have a personal fitness studio business and I have to have it coded whether it is for the personal training or group training income. We like the reports that can be generated in knowing which of our clients are paying for group or personal training. I have tried to edit the deposit screen and change the undeposited fund category to one that I need, but, it won't let me change it. So, that is when I decided that it was more important to have it categorized correctly in the deposit screen and then I would try to find another way to post that payment to the open invoice. Any suggestions?
You can rename the Undeposit Funds account name - but I don't see a need for it. The Undeposit Funds account is an account that QuickBooks automatically adds to your chart of accounts the first time you receive a payment from an invoice or sales receipt. QuickBooks uses this account to hold money you've collected until you deposit it in a bank account. So it really is just a holding account.
I strongly recommend that you continue using the receive payment option so you can receive against your invoices properly.
Where does that leave you? Well...
I think the question is your invoice/sales item list. What income account do you have your items directed to? In your chart of accounts you can set up two income accounts 1) group training income then 2) personal training income. When you create your items that you use on your invoices or sales receipts then you can direct the item to the particular income account that it pertains too.
When you pull up a Profit and Loss report you will be able to see the two different incomes. So you have an idea of how much income group training brought in and then how much personal training brings in.
Please write back if you have any more questions. Oh yea - here is how to rename the Undeposited Funds account if you want.
To change the name of the account
1. Go to the Lists menu and click Chart of Accounts.
2. Select the Undeposited Funds account in the chart of accounts.
3. Click Account at the bottom of the list and click Edit.
4. Enter a new name for this account.
Some suggestions for new names: Sales Income Holding Account, Payments Received, Funds from A/R, or Payments to be Deposited.
5. Click OK.
Your question is very general - but one suggestion would be if you are certain there is activity in that account then make sure that on your quick report the dates are correct.
Question:
Credit Card Processing Fees Aug 06, 2006 07:55 am
Hi Erin:
Thanks for being our expert!
I sell stuff on a website and I accept credit cards.
Whenever a customer uses his/her card to pay for a purchase, I am charged a fee by the credit card processor. For example, if a customer buys $100 worth of stuff, my bank account is credited for $95.00
($100 - the card fee) How do I account for the credit card transaction fee? Can I do it directly on the invoice?
I hope this makes sense because it has me stumped.
I am self employed and use QBP for all my accounting - and it's great! But I often travel for extended periods of time and can't always access my home desktop on a regular basis. Is there some way that I can install some version of QBP on my laptop, which travels with me and then somehow synchronize the two when I return to home base?
I have two suggestions - 1) you should look into QuickBooks OnLine. You can access it from anywhere as long as the internet is available. It is very slow if you use dial up but great if you have DSL. It offers the same features as Pro so you wouldn't lose any functionality. It really is great. I had a client that he accessed it from the United States and his colleagues accessed it from three other countries!!
I am not sure if you are on multi user or not - but if you have a single user version on your laptop and desktop and it is just you - you can do a backup and restore each time. Just be very careful... you don't want to restore over something that you inadvertently keyed onto your desktop that your laptop didn't have.
Question:
How do you hide the markup on an invoice? Aug 06, 2006 08:22 am
Hi Erin,
When purchasing an item for one of our customers, we add a transaction to our corp credit card in QB and mark the transaction billable. Then when we go to create an invoice, it comes up under Time/Costs. So we click on Expenses under Time/Costs and there it is. However, when we choose to mark it up by a percentage or a flat rate, it adds the markup to the invoice on our screen. This is fine, however, it then also shows the markup on the invoice when e-mailing and/or printing the invoice. This of course is not acceptable as we would prefer the customer to not know how much we have marked up the price of the item.
Is there a way to hide the markup that is added in Time/Costs? We know you can do it in on an estimate by going to customization of the invoice template and un-checking the box for Markup next to Print, however, we cannot find a way to do this when added to the invoice under Time/Costs from a charge to our credit card account.
Hi Brad - I can understand that you wouldn't want the mark up percentage to show on your invoice. If you go into EDIT then click on TEMPLATES then Hilite the template you currently use and double click on it. Then go to the Column tab and click the PRINT button off for the mark up column.
This will be clear when you are in there and see what I am talking about.
Dear Erin,
I issue about 100 to 150 invoices each week.
It's a time consuming process to open each one to tick the print box, and then save, before I can use the "Print Forms" feature.
Is there a quicker way to print a batch of invoices without having to individually open each one?
Also, is there any feature to place a stop warning on a customer if they are seriously overdue?
When your invoices come up to be invoiced/printed they show up under Reminders. If you go into Company then go to Reminders it shows Invoices to be printed. Then you can go to File Print Forms click on Invoices and all your invoices will be there.
I run a business on a cash basis. Simple start seems to defer everything to accrual. I would like to use the estimate and invoicing feature, but don't want every invoice to go to a/r since I don't report that way. If this program is not sufficient to accomplish this, which one is?
Many thanks.
You can go into EDIT then go down to PREFERENCES then click on REPORTS & GRAPHS - then change the Summary Report Basis to reflect cash basis versus Accrual basis.
Or on each individual report you can go into MODIFY REPORTS and change the REPORT BASIS to reflect cash basis.