Mar 02 2023 06:39 AM
How does the Excel invoice tracker template work?
How do I use it with my individual invoices?
Mar 04 2023 07:18 AM
How does the Excel invoice tracker template work?
How do I use it with my individual invoices?
You've had over 100 views and no replies. May I suggest that you'd be more likely to get a helpful reply if you let us know specifically what template you are referring to--not just by description, since there could be many fitting that description.
Ideally put a link in to the specific template. But since you have a copy yourself you could also put your copy on OneDrive or GoogleDrive and paste a link here that grants access to it.
Mar 06 2023 11:49 AM - edited Mar 06 2023 11:51 AM
OK. Now back to your original questions:
How does the Excel invoice tracker template work?
First of all, that template does nothing but give you a place to record the pertinent information on:
(a) invoices sent
(b) payments received
It does NOT, in short, serve in any way to create the invoices in the first place. It's a tracker.
How do I use it with my individual invoices?
You replace the information that's there for illustrative purposes with some of your own.
However, having offered those answers, I am compelled to add these comments: this template is very poorly designed. For several reasons. May I ask where you got it? If the source was Microsoft itself, I'll send some feedback to the department responsible for templates. I hope that's not the case, because it's so poorly designed it should never have been distributed.
Here are two of the reasons I say it's poorly designed:
There are ways both of those circumstances could be resolved, but it would be easier to start from scratch. Which, frankly, means it's not a template I'd recommend you continue even trying to use. It needs at the very least to be re-designed from top to bottom.
Let me ask you again, therefore, where you got this. As noted, if it's directly from a Microsoft source, I'll send feedback to the department responsible for templates. If it's some other source, you could send them my observations.
And moving ahead, let me ask you what you'd want an invoice tracking system to be able to do, and maybe we can find one, or create one from scratch. Again, realize that ALL this one purported to do was Track; not Create invoices in the first place.
If all you want is tracking, what do you need to track?
If you want to create AND track, then describe that fully as well. But also go to Microsoft's Template page and look there.
Mar 06 2023 12:22 PM
I agree that is why I'm asking about it. I gor it off MS. I have retired from my contracting business in which I used QB for 30 years. I don't want to to continue with QB because of the expense. I'm doing some consulting and I just need a way to track invoices which I am creating in Excel. I would like these to automatically record in a work book where I can see all invoices and their status. Thus I downloaded the invoice tracker which basically does nothing.
Jon
Mar 06 2023 12:31 PM
Can you find that on the Microsoft site for me, and paste the link here. I couldn't find it, didn't find anything like it. It's important to give them the feedback.
I'd be happy to help you develop an invoice tracker, but you'll need to describe your needs a bit more fully.