Les tables Xero dans Sheets

Sheets lit votre organisation Xero sous forme de 16 tables. Ajoutez-en une à un tableur comme source de données et ses colonnes deviennent des noms utilisables dans vos formules.

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…