Las tablas de Xero en Sheets

Sheets lee tu organización de Xero como 16 tablas. Añade una a una hoja de cálculo como fuente de datos y sus columnas se convierten en nombres que tus fórmulas usan.

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…