The Xero tables in Sheets
Sheets reads your Xero organisation as 16 tables. Add one to a spreadsheet as a data source and its columns become names your formulas use.
Sales
InvoicesID, Invoice no., Reference, Date, Due date…QuotesID, Quote no., Reference, Title, Date…Credit notesID, Credit note no., Type, Reference, Date…Invoice linesDocument ID, Invoice no., Date, Contact, Contact ID…
Purchases
BillsID, Bill no., Reference, Date, Due date…Bill linesDocument ID, Bill no., Date, Contact, Contact ID…Purchase ordersID, Order no., Reference, Date, Delivery date…
Bank
Accounting
Manual journalsID, Date, Narration, Status, Amounts are…Chart of accountsID, Code, Name, Type, Class…
Lists
ContactsID, Name, First name, Last name, E-mail…Products and servicesID, Code, Name, Description, Sales price…