Reports & Accounting
Recently active
In my field of property management, a tenant invoice total could be derived of several items. When performing month end reports for financial purposes, we need to provide total paid dollars PER ITEM. I created my OWN Excel spreadsheet per property with all the items that pertain to that properties billing, but it's a lot of time consuming back 'n' forth from QB to excel filling in the item column blanks per tenant paid invoice. Is there a way to print a "received" or "paid" dollars report that segregates the line items? If it can't segregate per item and only break down the item information per tenant invoice, I can upload into excel and manipulate the rows/columns - because I also need to TOTAL each column. (ie: Base Rent dollars, vs. Operating Exp dollars, vs, RE Tax Reimbursement dollars, vs. Utility dollars, vs. Prior Year dollars, etc.), these are some of the items. Any items that apply to said paid invoice should appear on this report for uploading i
I have made sure that they are recorded as a transfer between accounts when posting.
Original commenter did not share additional details
How can I see a report for a time frame of payments that were received but left as credit memos without being applied to invoices? Thank you
Sorry without zero quantity sku's showing up on report, i.e. only want to see inventory report of what we have on hand.
The base currency for my Quickbooks is Canadian dollars (CAD), however I also have one British pound (GBP) bank account. We frequently receive payments into our GBP bank account from UK businesses, and we then exchange this into CAD and transfer it to our CAD bank account. As of the 23 March 2020, our GBP bank account has a zero balance. We've transferred all our money to our CAD bank. You can see this here: However when I run a balance sheet as of the same day (23 March 2020), our GBP account is showing a negative balance. I can't work out how this can be possible. If I have a zero GBP balance and want to convert it to CAD, regardless of the exchange rate - anything multiplied by zero is... zero. The frustrating thing is that I can't even use a journal to correct the problem. If I try it just pushes the problem the other way. I end up with an incorrect closing balance on my GDP bank account (by about £1,841) but the CAD balance on my balance sheet
We did work for a customer and sent off the invoice. The work done was hanging a sign for a community event. They have now asked that we donate this time to the event. How is the best way to cancel this invoice? Should I credit the accounts receivable and record as a donation?
I can no longer open the tax detail download file with excel. If I open with another app, the file is blank.
Hi, This is super frustrating and I can't find anyone else with the same question. I'm running an Inventory Valuation Summary, rows showing set to Active, but no matter what I changed, it only runs the report with Inactive items. I cleared my browser cache, same problem. Only several days ago, I remember running this report and it was fine, showed active items. I had just put my items into categories, so it was grouped by categories. I was pretty satisfied. Now suddenly it ONLY shows inactive items and won't change. Is this a known glitch? Is there some way to fix this? Thanks.
