The active invoices in the dashboard includes paid invoices.
I’m not sure what you mean by “credits or overpayments” but I suggest creating a blank company and running some tests to see if you can reproduce the problem.
I was just mentioning/wondering if because I do deal with credit and in some cases have applied an overpayment to an invoice (essentially credit that is then used towards another invoice) if that could be where the difference is coming from. I have only used the overpayment a couple times but have found tracking extra payment as actual credit to be a better way.
Let me ask this…how is the “Invoices” dollar amount calculated?
The screenshot is for the React app, do you see a different number in the Flutter app?
In the Flutter app the invoice total includes invoices which are:
- Marked as sent
- The invoice and client aren’t deleted
- Is not cancelled or reversed
- Date is in between the start and end dates
- Currency matches selected currency
Numbers are the same for the year totals:
When looking at a complete list of invoices in both react and flutter app, ALL invoices are marked paid accept the one for $1620 (shown in screen shot in other post).
Both show the deleted invoices (all for $0) that I used for testing back in January.
I have no deleted or archived clients with invoices associated.
We only deal in US currency.
I do have some deleted payments and deleted credits but these were corrections or changes…these should not affect the invoice dollar amount as I understand.
If the Flutter and React apps match exactly I don’t think it’s likely there’s a problem in the app.
I suggest picking one month’s data to see if you can find a problem with it.
Forgot to mention i also have some quotes I have done. I use quotes more like a price list for potential clients. They get sent, I let them expire and then delete them so they never get converted. Just another thing I thought of but again from your list above these should not affect invoice totals.
I will keep looking but everything is correct. We do a month end every month (usually mid month too) where we sit down and review invoices and expenses. I’m still kind of hoping I’m just missing something that is being considered as part of the invoice amount that isn’t really an invoice. I take daily database backups and restore to a test instance. I’ll get the test instance sycn’d up but I’m pretty much out of ideas.
I’m down a rabbit hole trying to figure this out and I stumbled onto another issue. I was running different reports to try and compare the numbers…When running a profit and loss report the Total Expense dollar amount is not correct. I can add up the listed expenses and it comes up to the higher (correct) amount. I have correlated this to two recurring expenses I have setup. Each time an automated recuring expense triggers, the expense exchange rate is a 0 (zero) where all my other manually entered expenses appear as an exchange rate of 1. My currency is USD and I do not deal with any other currency or exchange rates. When I look at the automated expense entries in the app…the currency settings between the automated expenses and my manual expenses are identical. The difference in the Total Expense dollar amount, is the exact amount of these automated recuring expenses show a 0 (zero) for the Expense Exchange Rate.
This is probably unrelated the issue I am having with the invoice total that this thread is about but at this point I just don’t know and I am very concerned about the accuracy now having found another issue.
Manual fix for this was to “simply” open each affected instance of a recuring expense, change nothing but then save it again. A new expense report short the Expense Exchange Rate now to be a 1 like all other manually entered expenses. I have deleted all recuring expenses for now and will enter this on the github issue tracker.
Holy moly I think I figured this out!! After running numerous reports and scouring them I came to the same dollar amounts. What appears to be happening here is close to one of my previous assumptions…
I will be submitting another issue via Github. @hillel Thanks for hanging in here with me although I am kind of surprised no one else has run into these issues before me.
Another reply…while I think I understand what is happening here as mentioned yesterday…It seems to be self inflicted. So within this system a CREDIT does not equal a PAYMENT. The “Payments” value on the dashboard does not account for any credit values. -This is is where I messed up. Clients pay us in advance for lessons and I have been entering those “payments” as CREDITS. None of these credits are being accounted for as actual paid amounts in the system even though they where applied to invoices. I think basically what I have made it look like is a whole lot of free services…I think I now have to figure how to convert those credits to payments…OY!
Any help on the best way to correct credits that should be payments? I have outlined here and on github the only ways I can think of but was hoping for some confirmation that it will not have other negative affects.
Recap: In a test instance I simply created a payment with the same value and date as the credit. I then deleted the credit and all invoices paid by the credit became “unpaid”. This made it easy to simply apply the payment to those invoices. The only thing that might be off in this scenario is the payment date but I don’t see this really being a problem for us. The biggest thing is I need to show that these “credits” I entered where actually payments received from clients.
Maybe you can just include the credits when calculating the totals?
I just ended up doing what I mentioned above. Deleted the credits (and associated payments) and replaced with a payment for the same amount as the original credit and reapplying that to the invoices.
Still hoping my feature request about being able to have a payment behind a credit is considered so we can use the functionalities that come with credits. Next is to figure out how to keep clients informed of their payment balance without the use of the client portal.