Square + Invoice Tracker

Inspiration

Invoice Tracker V1 is useful, but it takes some efforts to key in all the invoices. Using Square Invoice API helps to reduce the efforts.

What it does

1. Retrieve invoices using Square API
2. Track all invoices in one place
3. Identify which invoices are past due and how late they are
4. Calculate how much amount is outstanding 5, Calculate expected payments in immediate future
5. Easy to identify due amounts by Customer
6. Simple and easy to use

How we built it

We use Invoice API and Google Sheet Apps Script to build this new version of invoice tracker.

Challenges we ran into

We did not run into much challenges except one formula uses subtotal() function assuming the invoice number is of type NUMBER whereby the invoice number retrieved from API is of type TEXT. Changing the function code of subtotal() function from 2 to 3 solves the problem.

Accomplishments that we're proud of

We made the Invoice Tracker V2 working.

What we learned

We learned the Invoice API, Apps Script and some Google Sheet's shortcuts.

What's next for Square + Invoice Tracker

1. Add Square Estimate and convert estimates to invoices.
2. Send reminders from Invoice Tracker.

Built With

• api
• app
• google
• script
• sheet
• square