Xero-tabellerna i Sheets

Sheets läser din Xero-organisation som 16 tabeller. Lägg till en i ett kalkylark som datakälla så blir dess kolumner namn som dina formler använder.

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

PaymentsID, Date, Amount, Type, Status…Bank transactionsID, Date, Type, Reference, Contact…

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…

Reports

Profit and loss (by month)Section, Account, Account ID, Month, Months ago…Balance sheet (by month end)Group, Section, Account, Account ID, Date…Trial balance (today)Section, Account, Code, Account ID, Debit…