Yanature Accounts

Sign in with your admin credentials.
📊 AccountsYanature accounting
InvoicesQuickBooks CSV export
ExpensesComing soon
P & LComing soon
CashflowComing soon
VATComing soon
⚙ SettingsGAS URL config
—
Yanature admin

Monthly invoices

Generate QuickBooks-ready CSVs from the master booking data. Pulls bookings from the chosen month, groups by agent and emits one invoice per agent per company.

1. Pick the period & starting numbers

Yanature and Nature Discoveries are generated separately.
Defaults to 11th of next month
Defaults to invoice date + 30 days
How this works
  1. The dedicated Yanature Accounting Master Google Sheet pulls each month's bookings from YN + ND, filters BILL = BILL, and exposes a clean Web App for this site to read.
  2. Click Load bookings → app refreshes that sheet's bookings_YYYY-MM tab live, then renders the invoice preview.
  3. For OTAs (Viator, GYG, etc.) the REF column is the ItemDescription (voucher). For local agencies without a REF, the NAME is used.
  4. Download the CSV per company → upload into QuickBooks. The app logs every generated invoice in the invoices_log tab.
⚙ ONE-TIME SETUP — create the Accounting Master sheet
  1. Create a new blank Google Sheet, name it Yanature Accounting Master.
  2. Inside it → Extensions → Apps Script.
  3. Replace the default Code.gs with the file Claude provided (YanatureAccountingGas.gs on your desktop).
  4. Save, then from the editor toolbar select function setup → Run (authorise when prompted).
  5. Run function installDailyTrigger once (sets auto-refresh at 3am).
  6. Deploy → New deployment → Web app → Execute as: Me, Who has access: Anyone → Deploy. Copy the Web app URL.
  7. Click ⚙ Settings in the sidebar here → paste that URL → Save.
  8. Click Load bookings. Done — fully automated from now on.