The acctStatement sheet
Allows you to view operations for a single account, for the period and currency of your choice.
The period and currency are defined in the “summary” tab.
Example
In the “PAYMENTS” tab, we recorded two payments from our HOTELABC client, which caused our account to have a $0 CAD balance. At the start of document period, as you can see in the “charts” tab, HOTELABC owed us $500 CAD.
If, in the “summary” tab, you set the reporting period to Jan 1st to Jan 31st, and the report currency to CAD, then head to the “acctStatement” sheet, you will see that the account balance at the end of the period is $0 CAD.
Next, in the “summary” tab, set the report start to 2020-01-10. This will exclude the first payment. Now, the balance is still $0 CAD, as it should be, but the operations before Jan. 10th are not described, but rather grouped into a line “Operations between 2019-01-01 and 2019-01-10”.
Next, in the “summary” tab, set the reporting currency to USD. The balance is $0 USD, but now, to compensate for the exchange rate changes over time, each transaction has an “Exchange adjustment” which is difference between the date of the transaction and the end date of report.
The sheets in detail
- instructions sheet: Any instructions such as what to do monthly, which source to import exchange rates from, etc., can go here.
- sandbox sheet: Has no incidence on your reporting, can be used to test ideas, functions.
- variables sheet: Global variables related to the document such as your base currency.
- verification sheet: Consolidations verification inforation from all other sheets, and makes a master verification cell available to all sheets. If it is zero, checks pass; if it is not zero, there are errors.
- chart sheet: The chart of accounts and how much money is in each account. A good overview of your assets, liabilities, expenses and income.
- facets sheet: Allows grouping of accounts in the chart of accounts.
- journal sheet: The journal of operations which is generated automatically from the imported data (sheets starting with "imp") via the intermediate sheet intJournal. Do not modify this directly.
- summary sheet: Running balance sheet, and any other high-level reporting, for the desired period. This sheet also lets you select a period and currency for all your reporting.
- current page: acctStatement sheet: View operations related to a single account in the desired period, in the desired currency.
- log sheet: Supports the good practice of logging important work done on the document, for example monthly importing of data from your bank.
- partners sheet: All your partners.
- ACMEBANK sheet: Most organizations will import data from various sources; this is an example import short.
- PAYMENTS sheet: Example data import sheet allowing you to enter payments.
- MANUAL sheet: For "exceptional" operations which do not fall into any of your data entry sheets.
- LINE sheet: For "exceptional" operations which do not fall into any of your data entry sheets.
- INVOICES sheet: Display and print invoices.
- Invoice sheet: View and print an invoice.
- intJournal sheet: An intermediate sheet which colladates data from "imp" sheets and prepares them for the automated journal.
- forex sheet: Define your available currencies, and import daily rates.