Tabele Xero w Sheets

Sheets czyta dane Twojej organizacji w Xero jako tabele (16). Dodaj jedną do arkusza jako źródło danych, a jej kolumny staną się nazwami, których używają Twoje formuły.

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…