Reports and accounting
Recently active
My customers are showing invoiced and payment made
I have two specific vendors that often we will return parts for, so we have many credit memos for the returned parts. However, when I look at my open balance for bills to be paid for said vendor, it is way higher than the actual amount because it is not taking into consideration the credit memos that should be subtracting from the total open balance. Is there a way to fix this?
Original commenter did not share additional details
I am trying to re-classify my thousands of records (really 10,000+) with the proper Location. It’s been a grind. Anyway, I’m sure I’ve missed some along the way. Is there a way I can find all transactions missing a value for Location?
I just started working for a small NPO. We're using Desktop Pro Plus 2020. I've cleared most of the old transactions, but there are a dozen I don't know what to do with. These were never reconciled, but have been paid or deposited. Some date back to 2018. Is there any way to clear them off the books?
Hi,I'm using quickbooks self employed and just want to keep track of expenses vs. income. I have a problem where a vendor that I purchase from takes a deposit when I make an order and then sends a receipt for the deposit plus the rest of the order. Fine. But quickbooks notes each transaction separately so when I upload the one receipt I have for the job, the numbers don't match. From what I understand there is no way to merge two transactions under one receipt. Is this true? Does this discrepancy matter? Thank you.
After changing a reconciled transaction from a utility expense to repair & maintenance expense it changed the nature of the transaction from a credit card expense to a credit card credit and will not let me change it back to an expense
Hello, I am trying to figure out the following transaction. Business is a boat dealership. Historically when clients trade in boats for new boats we 1) create a bill and input item purchased (traded in) at trade in value with negative offset going to Client Trade Liability account. This creates a zero bill. 2) when we are ready to invoice client for new boat we add in trade as a separate line item (negative). This reduces what they owe and also reduces taxes they owe. It also removes the liability. The system works well for keeping track of our liabilities and properly accounting for sales tax. Issue I have is client traded in boat for value of $150k. We needed to payoff the loan which was $100k to bank. I am having trouble using the above system because I am not sure where the $100k check should be logged to. We took possession of the boat and sold it weeks later. Just need a fresh set of eyes. Appreciate the help
We use QB Enteprise Desktop and are thinking about moving to QB Online. We use at least 3 custom fields or columns when we enter vendor or customer invoices. For example we have fields for Dept, office, and attorney. These fields appear when we run any reports and we can sort by those fields. I see that you can create a custom field in QBO, but can you multiple fields? It appears that you can filter by that custom field, but can you run a report with all of the fields so that I can generate Excel reports and pivots from there?
Is there a way to print out or export a list of my bundles and the items?
We itemize flat fees and non inventory items on an invoice. I want to post the proper expenses against the correct item on the invoice so I can see by line item what was spent and what is left to spend. We have the online construction pkg. I have tried everything.
We are a small custom construction company and we use the Project function to track project level financials. In projects we will see customer payments, related Bills (for special order materials, services & rentals), and Time Activities for labor spent on that job. The bills & time activities help our project managers know the amount of costs involved with the project so far. There is a third cost type, which would be materials used from Inventory. While we don't track inventory through QuickBooks, we would like the 'Charge' the project for the use of those materials we keep on hand. For example, if 100 linear feet of aluminum tubing is used, lets say it's $1 per foot, we'd like to see an expense on that project for $100 but not have that affect our overall company level books because from an accounting perspective, we've already bought and paid for that $100 worth of aluminum. Please let me know your ideas of how to best accomplish this. Thanks!
I'm not seeing the option in the pull-down menu for payment account when attempting to enter a new transaction. I have input an expense previously and had the account show, but now it is not there. And if I try to add the credit card account, I am told it is already an existing account.
QuickBooks Desktop 2020I typically enter bills and use Items to categorize the materials for a remodel job, then mark the item as billable on the bill so that when I generate an invoice I just add the materials from all the bills using the 'Add Time/Costs' feature. This creates a 1:1 ratio and no markup on materials. Some materials take a lot of time to source and customer interaction so I'd like to markup the material itself on the invoice, but if I do that then the P/L doesn't really show that markup as labor, which is what it technically is. When I enter the bill I can't alter/change prices or add a labor charge or it will throw off the bills.If I change the item price inside the invoice then that just throws off the books.Is there an easy way when using Items in QB Desktop to correlate markup on material to a labor category?
I ran a report of bills with the filter for unpaid bills. The problem is that it listed bills that were partially paid. It is OK for Quickbooks to do that, but it needs to also list the balance owed, not just the original amount.
Hello,My company received a $159,400 loan with $46.49 interest and I want to record it using journal entries. Can I proceed as follow: Loan receivedDebit: Bank account 159,400 credit : loan account 159,400 Loan repaymentDebit: loan account 159,400 Credit: bank account 159,400 Loan interestDebit: interest expense account 46.49 Credit: loan account 46.49 Interest paymentDebit: loan account 46.49 credit bank account 46.49 Thanks
I would like to add numbers to line items. This would make it easier when discussing with customers. If I could say line item number rather than the X rows down.
I was told by QBO that they had 3rd party vendor do mailing and vendor is behind.
I had a payment deposit into my QuickBooks checking account. I attempted to transfer the deposit to an envelope within QuickBooks, but the transfer said failed. When the transfer failed the money disappeared from the checking account. Later, the transfer says complete but the money was never transferred to the envelope and it is not in the checking account. I have been on 10 calls and no one has any answers or knows what's going on. I tried to get in touch with supervisors but I never received the 4-hour later call. Most of the reps are from a different country and it is hard to understand them. The only response I have received is there is a glitch in the system and they need time to figure it out. Now I am missing funds and accumulating late fees for not paying for stuff because of this "glitch".
