See the Privacy Policy

This is my version of Gazelle and Xero rolled into one app, since I don't want to pay the prices required for either of those, and don't have the throughput to justify either.

Contact Matt if you would like to use this system. You will need to give me:

• An email address from which you want your invoices to be sent (You will be sent a link, and will have to click on it, to verify that we can send emails as though they came from your address)
• A company logo of some sort or another, to put at the top of your invoices

I assume:

• You/your company are GST registered and will collect GST on your invoices.
• GST is 15%, the current value in NZ (If anyone outside NZ wants to use this, I could make this customisable by user).
• You are OK with the format of the invoice that I generate here, which should be a NZ tax compliant invoice. See a sample invoice to see what it looks like. Your logo, email, bank account, etc. will be used. If you are in another country, we can talk about what your invoice should look like. I haven't built that functionality yet, but it won't take much.

Data model

Customer

1. Name and/or organisation name
2. Phone
3. Address
4. Email
5. GPS coordinates (easily found from the address using Google Maps, or use the GPS on your device while you are on site)
6. Notes - any other information you may want to store about this customer
7. Pics - related to the customer

Piano

1. Make and model
2. Serial #
3. Year/age
4. Address/GPS coordinates (if not at same location as the customer)
5. Notes - any other information you may want to store about this piano
6. Pics - related to the piano

Piano work record

1. Date and time
2. Notes
3. Pic - related to the work record

Relationships

• Customers can have any number of pianos
• Pianos can have any number of work records (future work records are considered as appointments)
• Pianos need not be linked to a customer - these are known as orphans
• Work records, pianos, and customers can have any number of pictures attached
• Work records need to be linked to a piano - they can just be related to the customer
• Work records with a future date/time are considered as appointments

Search paths

Provided you keep your records accurate and for each customer record their address and GPS, and the make and model of their pianos, you will be able to do:

• Customer search by name or address
• Piano search by serial #
• Find the piano that I'm currently sitting in front of (Your device will ask if it's OK to use your location, and you have to allow it)
• Find pianos nearby to where I'm currently sitting ("I've had a cancellation and you haven't had your piano tuned for 2 years. I'm 5 min away. Would you like your piano tuned?"
• Customers nearby to a given customer ("I will be in your neighbourhood on Wed. Would you like your piano tuned?")
• Walk the make/model tree

Appointments

• Future dated work records are considered as appointments
• Your appointment schedule appears on the home page
• Driving directions from one appointment to the next on the same day are available from Google maps

Other features

• Mark Customers as on the lookout for a piano
• Mark pianos as available for sale
• Mark pianos as condemned (With techs' permission, I hope to one day create a nationwide condemned piano database)
• Waitlists with different categories
• Last tuned report - to identify how long its been since people have had their pianos tuned (reminder system will be coming)

Pricing

Not formalised yet. This isn't my main work, and I don't have time to make it look polished and seamless. It's what I use. If you find it useful, great. Let's talk. I would expect to be able to send you an invoice once a year or so to help cover the costs of cloud computing. Somewhere there are machines that run this stuff, and it costs me to use them. It's not going to be price gougingly greedy, however. It will never be more than 3 of your tunings per year.