The last seven days
| Date | Job | Bought by | Store | Amount | Card | What it was | PO | Status |
|---|
Keep the spreadsheet in step
Anything typed into LOG UPDATED.xlsm comes into the app on its own, twice a day. This is the other direction — it copies the lines that were logged here in the app so you can paste them at the bottom of your sheet. They come out in the same column order, and a line already in the sheet can never come back into the app twice.
Log a purchase
Find a hotel near the job
Book a stay
Stays on the books
| Check in | Hotel | Job | Nights | Rate | Total | Crew | Booked through | How was it |
|---|
Search the whole purchase log
Results
| Date | Company | Job | Foreman | Bought by | Store | Amount | Card | What it was |
|---|
The job list the front desk works from
| Company | Job | Type | In the tracker | Purchases | Spent through the front desk |
|---|
The roster
| Name | Role | Extension |
|---|
Company cards
The card list does not show itself. Type the last four digits of the card you are holding and only that one comes back.
Cards on the list
Every active card, shown by its last digit. A card added from this tab can be corrected or removed here. Cards set up by the office can be changed here too once Settings is unlocked.
Add a card
For a new card, or one that replaces an old card. Type the name and the last four digits only - never the whole number. Once it is in, it shows as the last four like the others.
A note on card numbers
Only the last four digits are ever kept here. If anyone needs a full number it stays where it is today — this app does not store one and never will.
Who logged the purchases
| Initials | Purchases | Spent | This month | Jobs | Stores | First | Last |
|---|
Everything logged under one set of initials
Their entries
| Date | Job | Bought by | Store | Amount | What it was |
|---|
Settings
Spending by store
| Store | Purchases | Spent | Last one |
|---|
Spending by person
| Person | Purchases | Spent | Jobs | Last one |
|---|
Spending by job, month by month
| Job | Month | Kind | Purchases | Amount |
|---|