Reports and accounting
Recently active
Service a Hospital with different locations which all have different accounts. Received a payment for a location that had already paid on an invoice and didn't have any open invoices so instead of leaving a credit on that account I sent an email asking if they'd like me to apply the payment to a different locations account which they replied yes and told me which account to do so. Well, I guess they were not supposed to tell me to do that and I had to give them a refund. Did the check, did the payment. Now to show that this account still owes on that invoice I applied that extra payment to I have to go into that payment and delete it correct? But then is that going to mess up my group deposit that its with? This is where I'm stuck. Please help! Thank you!
Or must I now manually add receipts to invoices? I'm sure I'm missing something. Thanks for your help!
Original commenter did not share additional details
Hi, I'm very new to Quickbooks Online so bear with me. For the Deposit Fees, I went into Accounts & Settings --> then Payments --> Chart of Accounts and under "Tell us where in QuickBooks to automatically record Processing Fees" I selected an account (not sure if I created it or not) called Quickbooks Payments Fees, which is an Expense account. I have several dozen online payments with Instant Deposit, totalling up to nearly $300 in fees, but I don't see any transactions recorded into that account, and I don't see it in the P&L under expenses, or basically anywhere. Is there something I have to do to create the actual expense to reflect the fees deducted? (I don't have my bank accounts linked so the bank deduction for it isn't going to show up anywhere) Somewhat related is my mileage expense recorded through the QBO app...why doesn't it show up in my P&L or in my Expenses totals?
When I run the standard Sales By Customer Detail report and select Custom Dates for the Report Period and enter only dates in the future, the report will run successfully and display accurate data on the screen but it will not export the data to Excel or PDF. The export just shows a blank page. Oddly, if I combine both dates in the past AND the future, the report will export successfully and shows both the dates in the past and the future. Am I missing something?
With Melio, I could send vendor payments the same day if scheduled by 12 pm. When using QB Bill Pay today, a Friday, I could only choose Monday or later. Is there any way to do same-day payments?
When I run the standard Sales By Customer Detail report and select Custom Dates for the Report Period and use only dates in the future, the report runs successfully and accurate data is displayed on the screen, but it will not export to Excel or PDF. The export is just a blank file. Oddly, when I combine both dates in the past AND the future, the report runs successfully and the export is successful as well, showing both the dates in the past and the future. Am I missing something?
Also, is it possible to change the status of an invoice from Draft to "sent" without actually sending through your system? Again, my invoices are ending up in people's spam folder. I simply need to generate a link and mark the invoice as sent.
Hi! Good morning, Can anyone help me out here? The owner transfers money from company checking account into company money market account, how do I categorize this in QB? What do I label the chart of account? Just want to make sure I am labeling everything correctly. Thank you in advance!
I am doing some reporting from QB Online Using Power BI. I use the Quickbook connector in Power BI to get data. I can not find the following info: Cost of sales at the line level (per transaction per item). The sales by item/service summary report does give COS but not on transaction level. As COGS is updated over time, QBO must store the COGS against the invoice data, and I can see a margin in some QBO reports so the data exists, but how can I find where it's stored to export it to Power BI? The Sales by item summary report does not have COS at all. Does someone know where or how I can get the required data (sales transactions with all the normal data of date, Customer ID, Item ID, qty, Unit price plus COS? Maybe an API that can help or combination of different tables?
I have some purchase orders that are linked to many bills - my vendor sends lots of partial shipments until the PO is complete. Some of my purchase orders are still open because I did not properly link some of these bills to the PO, and now I am going through them and trying to find the missing bills. What I need is a way to see what PO a bill is linked to, and I can then find the bills that are not linked. Is there any way to generate a report to see that info?
Where is my last year invoice
We have hundreds of memorized transactions and bill monthly. We are using desktop Pro 20196. As you know when you set up a customer you can choose Print Later or Email Later. We continually have issues where one or two boxes become unchecked. We don't notice this until we have a customer with overdue invoices and we discover that we have not been sending invoices. Is there a way to produce a report that would indicate if either box is checked or not. We would run it every month to insure that all the invoices we create are actually getting sent out. If this report is not available in Quickbooks is there a outside vendor that could design such a report? thanks
This latest update has caused our taxable customers to not be charged tax and QB keeps trying to calculate tax on my tax exempt customers. Also you cannot do subcustomers
under type of expense it no longer has items like job supplies or vehicle maintenance it only has asset or liability
On the stock status report by item I am shown - "on Hand"; "For Assembly"; "Available". The stock valuation only applies to "On Hand". What does "For inventory" mean?
I need to view the transaction history for a specific product over an assigned time. I have found reports that show all purchases, and different reports that show all sales, but no report that shows sales, purchases, and all other inventory adjustments in a single report. How do I run that report? The equivalent report in QuickBooks desktop is Inventory Item QuickReport.
I know there is a way to view bank statements and print them out does any one remember how to find the screen where one can print them out.
I have multiple customer's that require invoices be sent to a specific email address for invoices only. The same customer's require statements be sent to a different email address (not the same as the invoices). Can this be automated so I don't have to enter the different emails manually? Thanks.
Price Rules assigned to Customers for Sales Receipt transactions has not worked going back to 26 April. At that time frame Intuit had made changes to QB online software program which had removed the Price Rules from Invoices, Estimates and Sales receipt. This event made me close our store and send employees home. The Price Rules were turned back on after several days, but the Sales Receipt is still not working.When is this going to be corrected?
