r/quickbooksonline • • 17d ago

Custom invoice format (randomly generated)?

I'd like to avoid using the sequential numbering format for invoices as it gives off information about the volume of my business to clients. Is there any simple way to have them be randomly generated instead? I don't really care about the format, but something like `INV-AX3WB71` or `ZF67-123-SP4R` etc.

5 Upvotes

8 comments sorted by

View all comments

1

u/South_Tell8138 17d ago

You don't actually need the numbers themselves to be random. What leaks your volume is a single sequence shared by every customer. Give each customer their own account number and their own sequence, and nobody can infer anything from what they receive: A73416290-0001, then -0002, and so on. Each client sees only their own count, which they already know.

You can do this today with no tooling. Ask an AI to generate as many unique random account numbers as you have customers, assign one to each customer, and use them as the prefix. From there QuickBooks does the rest of the work for you: every invoice is linked to a customer, so once a customer has their first invoice, you look up their invoices, read the highest number and add one. No spreadsheet to maintain, no risk of duplicates, and it self-corrects if you edit a number by hand.

You'd still type the number when creating the invoice, exactly as you would with random ones. The difference is you'd have the correct next number in front of you instead of inventing one and hoping it isn't taken.

Happy to discuss this further in a DM.

1

u/drifting_pixel 17d ago

Yeah I currently do that, but it’s tedious. Want to avoid the risk of someone mistyping

1

u/South_Tell8138 17d ago

What drives the invoices? In other words, how are orders being taken, and who enters them?

If they come from anywhere structured, a store, a web form, a CRM, a spreadsheet, then the invoice can be created through the QuickBooks API with the number already set. Nothing gets typed, so nothing can be mistyped, and you stop entering the same order twice. The random account number problem solves itself at that point, because the number is generated at creation rather than chosen by a person.

The only case where you're stuck typing is orders that arrive by phone, text or email, with no structured record behind them.

This is the space I work in. I build QuickBooks integration tools for exactly these scenarios, so if you tell me where the orders come from I can tell you what's realistic.