Reports and accounting
Recently active
We seldom use this card anymore and are waiting for a refund. In the meantime, how do I reconcile it in QBS online? We have been waiting 6 months for the refund and QB's won't let me reconcile any statements. Error message says the account isn't ready to reconcile yet. The beginning balance off by the amount of the credit.
Help?We run the Invoice List standard report usually once a week or more to cross check current and compare previous time periods. Today the data is literally not there. It now reads "Your selection doesn’t have any info. Change your selection or start a new search." Nothing has been changed, no changes to filters, or anything else has been done. HELP?
I manage the money for student clubs at my school and am looking for a better way of letting the advisors know what transactions have cleared and what the account balance is. I would like a report that shows all the transactions for the fiscal year and the running account balance but does NOT show the “total” of the difference between credits and debits. The closest I’ve gotten to this is the Balance Sheet, but at the bottom it shows the total. The total just causes confusion, especially when the total is negative, as the advisors think that’s the account balance. I really wish I could make a report look something like a bank statement, with beginning balance, transactions, and ending balance. Is there a better report I should be using? Or is there a way to not show the total on the Balance Sheet?
Hi there, I'm not up to date on the latest features QB offers to streamline/automate this process but I have to think there's some features that provide these solutions. It seems as if this reporting hasn't changed in roughly 30 years and everything is done through manual excel entry. Are there QB functions we're missing out on that I should be aware of?
Is anyone aware of a labor distribution report in QB Online? With each pay period end, I would like to have a report that lists each employee and how the pay dollars were posted to the general ledger by account. This will help me monitor labor allocations and make necessary reclasses.
I like to produce certain reports for our owners and am looking to produce a budget report for 2024 by using an "expenses by vendor" report as a reference, but it will not let me filter it by class. Having multiple locations, I need to separate the expenses by location. I use a "separate by class" system to do this. I have been able to apply a filter to almost all our reports so we can see what location is doing what until now. I would like a report to show me expenses only by "class" (location) for the year. Anyone have any other report recommendations on a report that will help me where I will be able to separate the expenses for each specific class for the year?Worse case scenario, I'll have to take the info off the P&L...................
Original commenter did not share additional details
For instance, if I have stored card for customers that are no longer current, I would like to remove the unneeded info. i know how to remove the data. I mean If i knew that mr smith and mrs jones had cc info stored and we no longer needed it, i could remove it. The problem is finding out which mr smith and mrs jones even have stored cc info and combing through 2500 customers is way too time consuming.
Can i change column width on the transaction report in order to see amount column
Can i create purchase order in mobile app Qbo
When we create customer statements, we select 'All customers' and 'Do not create statesments: with a zero balance'. When we click 'Print' an error comes up that says: Quickbooks encountered errors while creating statement. This may be because of selecting too many customers. Try reducing the number of customers selected (Max of 4500) and create statements We only have a dozen or so customers with a non-zero balance. Is there a way to fix this without selecting 'Multiple customers' and selecting customers manually? We are using Quickbooks Enterprise 23. We were previously using Enterprise 20 and this message did not come up.
QBDT Pro 2023Looking for suggestions on handling the entry of bills, tracking due dates, and recording payment of vendors who are on auto-pay (normally drafted from our account). I prefer entering the bill for tracking and budget review purposes rather than simply writing checks without printing them, but would like to hear of some options that the community has used to simplify while keeping the GL current. Thanks in advance.
Hello, I have inputted the budget for our upcoming FY. However, if I look at a P&L for next FY, the total numbers are different than the individual budgets put together. If there is no class filter, there are extra numbers in the budget. If I select all classes on the class filter, the numbers are correct. This makes me assume there is an unclassified number. However, each class in the budgeting tool is correct, so there is no where I can change an unclassified number. I am grateful for any ideas on how to solve this.
I work for a nonprofit, and we do not have our bank account connected to QBO. For audit, they want to see every transaction from each account, monthly, in one report. I customized a transaction report by date that shows everything I need. However... It shows all transfers going out, but does not include the transfers coming in. Can anyone tell me what I'm missing? TIA
I have 20 pages on line of city/county rates. I want to compare it to what I have in Housecall Pro to be sure I match.
After the recent update, my memorized reports are not correct. It has dropped a couple columns and added two columns that you cannot uncheck in the filter. The added column are "act cost and act sales price. I have several reports and going in and trying to fix them would be extremely time consuming. Please help. Cindy
I am doing an manual conversion from QBD to QBO. The accountant has given me the detail to support the AP balance in QBD. The total does not match QBO. How can i get a report from QBO of the detail transactions that make up the QBO calculated opening balance? Thank you for your help.
While looking at my financials today, I see an item on my profit and loss report which falls under the "not specified" class. I clicked on the transaction and, within the transaction itself, the classes are set properly. However, going back to the report, the account that shows up is not what is used in the transaction either. I clicked on the new account and get a pop up screen stating "We created this account for bill payments without a matching bill. Find out more." I clicked on "Find out more" to see how to negate the change but the pop up window was unhelpful and did not address my issue.I entered this transaction how it needs to be entered but AI has changed it in the background somewhere so that it shows up differently on the financial reports than how it was entered. Does anyone know how I can fix this? If I delete and re-enter the transaction the way I need to, I assume the AI will do the same thing again. Is there a way to overr
I have a non-matching beginning balance on my bank reconciliation, I ran the discrepancy report and apparently I deleted a 2 year old check causing the discrepancy. I recreated the check using the same date that it was, that did not change the beginning balance. Then I proceeded to 'clear' the transaction in the check register and save and that also did not change the beginning balance. How can I reinstate this once 'deleted' check? Do I have to delete over a years worth of statement reconciliations to get back to that statement and have to reconcile all of them again? Thanks for your help.
Hi,We use spreadsheet sync to pull in our P&L each month by class (along with comparative periods). Each month we have to go to each class and update the date manually through the date picker. However, there is a formula option that allows you to select a cell or input a formula which I assume would allow us to have a dynamic date.I have tried every combination of date or value format within the cell or within the formula. In no case will the Spreadsheet Sync except the date for the filter. The date picker shows a format that is yyyy-mm, but that doesn't work either. Has anyone gotten a dynamic formula for the date to work in the filters of spreadsheet sync?
