As tabelas do Xero no Sheets

O Sheets lê sua organização no Xero em 16 tabelas. Adicione uma delas a uma planilha como fonte de dados e suas colunas viram nomes que suas fórmulas usam.

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…