Reports Question

[comone]

While pulling reports and trying to get a handle on the cash flow I noticed an area in my reports called Uncategorized (Any product on an invoice but not in the product database). This dollar figure can be well over $30,000.00 and I think I have it figured out as to what it is.

Monies carried forward to the next months invoice and late payment fees. I have tried to setup the late fees in the database and match them to the late fees being charged however this does not work.
In a future release it would be nice to have these to amount broken down on the report. I.e. along with all the other products in the database on the following report types have a line for late fees and carry forward instead of Uncategorized
- Payments Received by Category Report


In addition if possible, to have a report that will show all invoices in a given period of time that have Uncategorized items on the invoices.

[K Software]

I'm adding a new late fee feature to the next version that will let users add late fees as flat dollar amounts or as a percentage of the balance due.

You've found the disadvantage of using the balance forwarding feature - you lose categories because a "previous balance" could be from any number of items or invoices. Initially the balance forward feature actually pulled the items themselves off of unpaid invoices but I ran into a problem - partial payments. If an invoice is partially paid there isn't a reliable way to say which of the line items on the invoice the partial payment took care of so kBilling doesn't know which items to pull forward.

With the new late fee feature you'll be able to keep the individual invoices, charge late fees and use a customer statement to send bills to customers with more than one invoice. That means disabling balance forwarding for your customers (but that is now easily done with a global option for that feature). I don't think I'll eliminate the balance forwarding all together but the new late fees coupled with statements should give everyone what they need.

Thanks for the feedback and I apologize for this post being stuck in moderation for a few days.

[comone]

I can understand the issue with bringing forward the previous invoice and as I understand what you are suggesting you will not/would not use the carry forward feature as it is difficult to bring forward that information. Instead would it not be somewhat easy to bring forward a note on the next invoice about the previous balance and then add an argument to say current balance + previous balance display new balance. Where by the new invoice checks the customers account and displays the previous balance. If the previous balance is 0.00 it would then display as
Sub total 47.50
Tax 2.50
This invoice 50.00
previous balance 0.00
Current Balance 50.00

If a balance does exist then it would display
Sub total 47.50
Tax 2.50
This invoice 50.00
Previous balance 50.00
Previous balance fee 2.50
Current balance 102.50

How Kbilling is programed I do not know, but in its most simple form using if/then arguments it seems it could be done.

This should leave the item on the original invoice and still bring a balance forward for the custoer invoice including late fees, whether it be a defined amount or a percent of the previous balance field.

[K Software]

If every invoice displayed any other balance on any other invoice and you sent the client more than one invoice the balance due wouldn't be accurate since each invoice would have the other invoice's balance calculated into the total balance due.

[maurid]

Do U have a report that shows the items in stock, and the cost of the items?

[K Software]

Yes. Stock and product reports are available.

[maurid]

How and where can I get these reports?

[K Software]

On the reports tab from the main kBilling window. Select the Stock report from the drop-down list and click View Report.