Table of Contents
Reports
Supported Endpoints and Methods
The endpoint can be found at: https://api.reckon.com/R1/{BOOKID}/reports/{ReportName}
Methods supported: POST
The Book ID represents the unique GUID of the Book the user wants to write data to. For example c1b3da90-e9df-4d57-8cfb-71a1d7bfe401
Reckon One Module | Endpoint | Endpoint Parameter(s) | HTTP Method | Description | Release Version | API Portal | Countries |
Core | /accountEnquiry /false | POST | Retrieve all transactions from the book based on the parameters specified in the POST request |
| AU/NZ/UK | ||
Core | /profitLoss | POST | Retrieve the profit and loss report from the book based on the parameters specified in the POST request | 1.8 | AU/NZ/UK | ||
Core | /balanceSheet | POST | Retrieve the balance sheet report from the book based on the parameters specified in the POST request | 1.10 | AU/NZ/UK | ||
Core | /trialbalance | POST | Retrieve the trial balance report from a book based on the parameters specified in the POST request | 1.9 | AU/NZ/UK |
Valid Period Types
Period type is required to be sent with each Report payload.
- ThisMonth,
- ThisQuarter,
- ThisYear,
- ThisYearToDate,
- ThisMonthLastYear,
- ThisQuarterLastYear,
- LastMonth, LastQuarter,
- LastYear,
- LastYearToDate,
- Last3Months,
- Last6Months,
- Last12Months,
- AsAtToday,
- AsAtDate,
- This2MonthPeriod,
- This6MonthPeriod,
- Last2MonthPeriod,
- Last6MonthPeriod,
- AsAtEndOfThisFinancialYear,
- AsAtEndOfLastFinancialYear,
- AllDates,
- Custom
Example with custom date range
{
"Orientation":"Landscape",
"ReportingBasis":"AccrualsBasis",
"PeriodFilter":
{
"PeriodType":"Custom",
"StartDay":"2015-12-31",
"EndDay":"2023-12-31"
}
}Example with AsAtDate
{
"PeriodFilter": {
"PeriodType": "AsAtDate",
"EndDay": "2023-12-31"
}Supported Report Types
These are the reports that are available:
- accountenquiry
- trialbalance
- profitloss
- balancesheet
- top10suppliers
- top10customers
- ledgertransactions
- transactionlineitems
Sample
Retrieve the Account Enquiry Report
Endpoint: https://api.reckon.com/R1/{BOOKID}/reports/accountenquiry/false
Method: POST
Sample POST
{
"Orientation":"Portrait",
"ReportingBasis":"AccrualsBasis",
"PeriodFilter":
{
"PeriodType":"ThisMonth"
}
}Sample Response
{
"ReportBasis": 2,
"ReportData": [
{
"ID": "b9cf6144-1900-41f1-9c28-6cf86d662496",
"Name": "Bank - Bank",
"Code": null,
"ClosingBalance": 83351.3400,
"OpeningBalance": 83501.3400,
"Transactions": [
{
"Amount": -50.0000,
"Debit": 0.0000,
"Credit": 50.0000,
"BankAccount": null,
"Contact": {
"ID": "61ab8cef-0009-4d41-85b6-dff6d932371e",
"Name": "Ifti Chowdhury"
},
"Date": "2019-12-11T00:00:00+00:00",
"Details": null,
"ID": "e2cfdc84-c42e-4e8e-aebd-a162d35da8aa",
"Number": null,
"TaxCode": null,
"Type": "PAY"
},
{
"Amount": -100.0000,
"Debit": 0.0000,
"Credit": 100.0000,
"BankAccount": null,
"Contact": {
"ID": "61ab8cef-0009-4d41-85b6-dff6d932371e",
"Name": "Ifti Chowdhury"
},
"Date": "2019-12-11T00:00:00+00:00",
"Details": null,
"ID": "1dd6085b-57df-4407-99d2-dd17f4ab4e75",
"Number": null,
"TaxCode": null,
"Type": "PAY"
}
]
},
{
"ID": "b6eecd74-4271-4d8c-92cd-eadea5e88124",
"Name": "Accounts Payable",
"Code": "2-1100",
"ClosingBalance": 2594.0000,
"OpeningBalance": 2744.0000,
"Transactions": [
{
"Amount": -100.0000,
"Debit": 100.0000,
"Credit": 0.0000,
"BankAccount": null,
"Contact": {
"ID": "61ab8cef-0009-4d41-85b6-dff6d932371e",
"Name": "Ifti Chowdhury"
},
"Date": "2019-12-11T00:00:00+00:00",
"Details": null,
"ID": "1dd6085b-57df-4407-99d2-dd17f4ab4e75",
"Number": null,
"TaxCode": null,
"Type": "PAY"
},
{
"Amount": -50.0000,
"Debit": 50.0000,
"Credit": 0.0000,
"BankAccount": null,
"Contact": {
"ID": "61ab8cef-0009-4d41-85b6-dff6d932371e",
"Name": "Ifti Chowdhury"
},
"Date": "2019-12-11T00:00:00+00:00",
"Details": null,
"ID": "e2cfdc84-c42e-4e8e-aebd-a162d35da8aa",
"Number": null,
"TaxCode": null,
"Type": "PAY"
}
]
}
],
"BookName": "My Book",
"DateGenerated": "2019-12-16T00:53:58.5832931+00:00",
"ReportName": "Account enquiry"
}Details of each object
Data Field | Description | Data Type |
ReportBasis | Is the report basis Accrual or Cash accounting | Numeric
|
ReportData | Contains the report data | Array |
ID | Account ID | GUID |
Name | Account name | Alphanumeric |
Code | Account code | Numeric |
ClosingBalance | Closing balance of the account | Numeric |
OpeningBalance | Opening balance of the account | Numeric |
Transactions | Array of all transactions using the account in the reporting period ** Cash or Accrual method dependant | Array |
Amount | Amount posted against the account in this transaction | Numeric |
BankAccount | Bank Account used on transaction – Always null | Numeric |
Contact | Array of contact details – includes contact ID and contact name | Array |
Date | Date / Time of the transaction | Date/Time |
Details | Transaction summary or note | Alphanumeric |
ID | Transaction ID | GUID |
Number | Transaction number | Numeric |
TaxCode | Array of tax code details - name only | Array |
Name | Name of tax code | Alphanumeric |
Type | Type of transaction | Alphanumeric
|
BookName | Name of the Book containing the data | Alphanumeric |
DateGenerated | Date the report was generated | Date/Time |
ReportName | Name of the report | Alphanumeric |
Retrieve the Profit and Loss Report
Endpoint: https://api.reckon.com/R1/{BOOKID}/reports/profitloss/false
Method: POST
Sample POST
{
"Orientation":"Portrait",
"ReportingBasis":"AccrualsBasis",
"PeriodFilter":
{
"PeriodType":"ThisMonth"
}
}Sample Response
{
"ReportData": {
"Income": [
{
"ID": "3cd66851-0c68-47f0-8b23-0d8cfedda55a",
"Name": "caf9ff83-23bc-4106-b381-5aee5d0c2534",
"Code": null,
"ExportCode": null,
"TaxCode": "GST",
"ParentID": "00000000-0000-0000-0000-000000000000",
"Period1Amount": 48.0000,
"Period1Total": 48.0000
},
{
"ID": "82478296-b16f-4275-aae2-9e3b447afc29",
"Name": "Income",
"Code": "4-0000",
"ExportCode": null,
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Period1Amount": 910.2300,
"Period1Total": 910.2300
},
{
"ID": "0b881324-a501-4b4e-8607-faab144021d3",
"Name": "Sales",
"Code": "4-4010",
"ExportCode": "230",
"TaxCode": "GST",
"ParentID": "00000000-0000-0000-0000-000000000000",
"Period1Amount": 494.9800,
"Period1Total": 494.9800
}
],
"OtherIncome": [],
"COGS": [],
"Expenses": [],
"OtherExpenses": [],
"TotalIncome": {
"Period1Amount": 1453.2100
},
"TotalOtherIncome": {
"Period1Amount": null
},
"TotalCOGS": {
"Period1Amount": null
},
"TotalExpenses": {
"Period1Amount": null
},
"TotalOtherExpenses": {
"Period1Amount": null
},
"NetProfit": {
"Period1Amount": null
}
},
"BookName": "My Book",
"DateGenerated": "2019-12-16T01:01:09.8025619+00:00",
"ReportName": "Profit and loss"
}Details of each object
Data Field | Description | Data Type |
ReportData | Contains the report data | Array |
Income | Array of all income accounts | Array |
Other Income | Array of all Other Income accounts | Array |
COGS | Array of all COGS accounts | Array |
Expense | Array of all Expense accounts | Array |
Other Expense | Array of all Other Expense accounts | Array |
ID | Account ID | GUID |
Name | Account name | Alphanumeric |
Code | Account code | Numeric |
ExportCode | The export code that can be defined by the user against a chart of account item | Alphanumeric |
ParentID | ID |
|
PeriodAmount | Amount in the period | Numeric |
PeriodTotal | Total in that period | Numeric |
TotalIncome | Array of total income – Has one key value pair only – “PeriodAmount" | Array |
TotalOtherIncome | Array of total other income – Has one key value pair only – “PeriodAmount" | Array |
TotalCogs | Array of total COGS (cost of goods sold) – Has one key value pair only – “PeriodAmount" | Array |
TotalExpense | Array of total other income – Has one key value pair only – “PeriodAmount" | Array |
TotalOtherExpense | Array of total other expense – Has one key value pair only – “PeriodAmount" | Array |
NetProfit | Array of net profit – Has one key value pair only – “PeriodAmount" | Array |
BookName | Name of the Book containing the data | Alphanumeric |
DateGenerated | Date the report was generated | Date/Time |
ReportName | Name of the report | Alphanumeric |
Retrieve the Balance Sheet Report
Endpoint: https://api.reckon.com/R1/{BOOKID}/reports/balancesheet/false
Method: POST
Sample POST
{
"Orientation":"Portrait",
"ReportingBasis":"AccrualsBasis",
"PeriodFilter":
{
"PeriodType":"ThisMonth"
}
}Sample Response
{
"ReportData": {
"Sections": [
{
"Type": "Current assets",
"Accounts": [
{
"ID": "00528b6f-54d4-49e2-883f-c50abf86ca59",
"Name": "Bank - Cloud POS Cash Register",
"Code": null,
"ExportCode": "680",
"Period1Amount": 564.4600,
"Period1Total": 564.4600,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "831f1026-4b4c-49b1-9eee-4c5b71a5a6d8",
"Name": "Bank - Bank account via API change of instance 2",
"Code": null,
"ExportCode": "680",
"Period1Amount": 100.0000,
"Period1Total": 100.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "3582c163-072d-4710-b557-b47b0f5f721a",
"Name": "Bank - Bank account via API change of instance",
"Code": null,
"ExportCode": "680",
"Period1Amount": 100.0000,
"Period1Total": 100.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "50c35fbd-04cc-4796-bb84-5526f4d82806",
"Name": "Bank - Bank Account Via API 31-08-2018",
"Code": null,
"ExportCode": "680",
"Period1Amount": 100.0000,
"Period1Total": 100.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "464da53a-11a6-4470-ac72-73be4ffd5404",
"Name": "Bank - Cloud POS Cash Register 23",
"Code": null,
"ExportCode": "680",
"Period1Amount": 3917.2000,
"Period1Total": 3917.2000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "a704e85e-010c-4cf0-b7be-43f0b0659c83",
"Name": "Bank - RCPOS Cash Register 3",
"Code": null,
"ExportCode": "680",
"Period1Amount": 700.0000,
"Period1Total": 700.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "3daec792-0898-49a8-b808-283c7ea42faf",
"Name": "Bank - Bank Account",
"Code": null,
"ExportCode": "680",
"Period1Amount": 24.0000,
"Period1Total": 24.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "65992190-1e26-4d25-a56d-1492d9f1f358",
"Name": "Bank - New Bank via app 5",
"Code": null,
"ExportCode": "680",
"Period1Amount": 8900000.0000,
"Period1Total": 8900000.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "e51345d6-0f6b-4acf-a2d4-68e3d718983f",
"Name": "Bank - New Bank Account 4",
"Code": null,
"ExportCode": "680",
"Period1Amount": 20000.0000,
"Period1Total": 20000.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "0ce7d636-b67c-44ea-813b-a28ff9596ce6",
"Name": "Bank - New Bank Account 3",
"Code": null,
"ExportCode": "680",
"Period1Amount": 500000.0000,
"Period1Total": 500000.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "59b7107b-41e7-4a93-8a26-e5f1a008fa65",
"Name": "Bank - Bank updated via App",
"Code": null,
"ExportCode": "680",
"Period1Amount": -110.0000,
"Period1Total": -110.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "d129e51e-226e-41e9-907e-f18daf56869d",
"Name": "Bank - Tony Bank Account",
"Code": null,
"ExportCode": "680",
"Period1Amount": 4190.0000,
"Period1Total": 4190.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "c13ec354-9737-455c-bc34-d9024675d343",
"Name": "Bank - Bank 4",
"Code": null,
"ExportCode": "680",
"Period1Amount": -100.0000,
"Period1Total": -100.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "ec83afd2-4a3c-4d05-963c-df49c37f41f1",
"Name": "Bank - Cash",
"Code": null,
"ExportCode": "680",
"Period1Amount": 410.0000,
"Period1Total": 410.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "b9cf6144-1900-41f1-9c28-6cf86d662496",
"Name": "Bank - Bank",
"Code": null,
"ExportCode": "680",
"Period1Amount": 83351.3400,
"Period1Total": 83351.3400,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "8de07c43-7da6-4bcb-9413-b9c398d90e23",
"Name": "Accounts Receivable",
"Code": "1-1210",
"ExportCode": "662",
"Period1Amount": 610.9100,
"Period1Total": 610.9100,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "70fc511a-e48a-42b3-97eb-a29c7476908a",
"Name": "Finance Charges",
"Code": null,
"ExportCode": null,
"Period1Amount": -4.5000,
"Period1Total": -4.5000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "4eda6b0a-a92e-4a00-a167-f272cd901b72",
"Name": "Current Assets",
"Code": "1-1100",
"ExportCode": null,
"Period1Amount": -120.0000,
"Period1Total": -120.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
}
]
},
{
"Type": "Non-current assets",
"Accounts": []
},
{
"Type": "Current liabilities",
"Accounts": [
{
"ID": "c635a6d7-9357-4dbc-9bd5-73fa8523d5f7",
"Name": "Bank - Credit Card",
"Code": null,
"ExportCode": null,
"Period1Amount": -1000.0000,
"Period1Total": -1000.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "b6eecd74-4271-4d8c-92cd-eadea5e88124",
"Name": "Accounts Payable",
"Code": "2-1100",
"ExportCode": "883",
"Period1Amount": 2594.0000,
"Period1Total": 2594.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "7a154c27-a810-45cc-a0c2-779a9ba3e7f4",
"Name": "Super Payable",
"Code": null,
"ExportCode": null,
"Period1Amount": 1584.3400,
"Period1Total": 1584.3400,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "7ad51ffb-30b2-4788-b676-f0310c185c50",
"Name": "Payroll Payable",
"Code": null,
"ExportCode": null,
"Period1Amount": 6476.0000,
"Period1Total": 6476.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "fcd7f50c-bb54-41bc-a685-0bf92f936e13",
"Name": "GST Payable",
"Code": "2-1150",
"ExportCode": "895",
"Period1Amount": 0.0,
"Period1Total": 935.4500,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "572d9053-1846-4d78-86fb-bc20250fd278",
"Name": "GST Collected",
"Code": "2-1155",
"ExportCode": "895.00",
"Period1Amount": 1283.3500,
"Period1Total": 1283.3500,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "fcd7f50c-bb54-41bc-a685-0bf92f936e13"
},
{
"ID": "e5502479-eb39-49e2-959b-5ca94d1c9c02",
"Name": "GST Paid",
"Code": "2-1160",
"ExportCode": "895.99",
"Period1Amount": -347.9000,
"Period1Total": -347.9000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "fcd7f50c-bb54-41bc-a685-0bf92f936e13"
},
{
"ID": "9725fff0-399f-4915-9160-e9f219b6ceb3",
"Name": "Payroll Liabilities",
"Code": "2-1200",
"ExportCode": "868",
"Period1Amount": 0.0,
"Period1Total": 10878.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "9ee1ba89-fd40-4422-81cd-aebf213280c0",
"Name": "PAYG Withholding Payable",
"Code": "2-1220",
"ExportCode": null,
"Period1Amount": 10878.0000,
"Period1Total": 10878.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "9725fff0-399f-4915-9160-e9f219b6ceb3"
}
]
},
{
"Type": "Non-current liabilities",
"Accounts": []
},
{
"Type": "Equity",
"Accounts": [
{
"ID": "3b38544b-f4b3-4c2e-80ed-3b3734afe493",
"Name": "Opening Balance Equity",
"Code": "3-0100",
"ExportCode": "30000",
"Period1Amount": 9525300.0000,
"Period1Total": 9525300.0000,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "9fe2fc1b-2da4-49e0-9b6a-77b54ea49a52",
"Name": "Retained Earnings Surplus/(Accumulated Losses)",
"Code": "3-1000",
"ExportCode": "638",
"Period1Amount": -34487.5900,
"Period1Total": -34487.5900,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
},
{
"ID": "ffffffff-ffff-ffff-ffff-ffffffffffff",
"Name": "Current year earnings",
"Code": null,
"ExportCode": null,
"Period1Amount": 1453.2100,
"Period1Total": 1453.2100,
"Period2Amount": 0.0,
"Period2Total": 0.0,
"ParentID": "00000000-0000-0000-0000-000000000000"
}
]
}
],
"Totals": {
"TotalAssets": {
"Period1Amount": 9513733.4100,
"Period2Amount": 0.0
},
"TotalLiabilities": {
"Period1Amount": 21467.7900,
"Period2Amount": 0.0000
},
"TotalEquity": {
"Period1Amount": 9492265.6200,
"Period2Amount": 0.0
}
}
},
"BookName": "My Book",
"DateGenerated": "2019-12-16T01:03:58.1398569+00:00",
"ReportName": "Balance sheet"
}Details of each object
Data Field | Description | Data Type |
Type | The Type of data that is in the next Array | Alphanumeric |
Accounts Array | Contains all the accounts which is allocated to a particular area of the report such as the Current assets. | Array |
Name | The name of the account eg. Cash | Alphanumeric |
Code | The account code for the account | Alphanumeric |
ExportCode | The export code for the account | Alphanumeric |
Period1Amount | The amount allocated to the account in the set period | Numeric |
Period1Total | The total amount allocated to the account in the set period | Numeric |
Period2Amount | If a comparison period has been included, the amount allocated to the account in the comparison period | Numeric |
Period2Total | If a comparison period has been included, the total amount allocated to the account in the comparison period | Numeric |
BookName | The name of the book the report is from | Alphanumeric |
DateGenerated | The time the report was generated | Date/Time |
ReportName | The name of the report | Alphanumeric |
Retrieve the Trial Balance report
Endpoint: https://api.reckon.com/R1/{BOOKID}/reports/trialbalance/false
Method: POST
Sample POST
{
"Orientation":"Portrait",
"ReportingBasis":"AccrualsBasis",
"PeriodFilter":
{
"PeriodType":"ThisMonth"
}
}Sample Response
{
"ReportData": {
"Income": [
{
"ID": "3cd66851-0c68-47f0-8b23-0d8cfedda55a",
"Name": "caf9ff83-23bc-4106-b381-5aee5d0c2534",
"Code": null,
"Type": "Income",
"TaxCode": "GST",
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 48.0000
},
{
"ID": "82478296-b16f-4275-aae2-9e3b447afc29",
"Name": "Income",
"Code": "4-0000",
"Type": "Income",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 910.2300
},
{
"ID": "0b881324-a501-4b4e-8607-faab144021d3",
"Name": "Sales",
"Code": "4-4010",
"Type": "Income",
"TaxCode": "GST",
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 494.9800
}
],
"OtherIncome": [],
"COGS": [],
"Expenses": [],
"OtherExpenses": [],
"CurrentAssets_Bank": [
{
"ID": "00528b6f-54d4-49e2-883f-c50abf86ca59",
"Name": "Bank - Cloud POS Cash Register",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 564.4600,
"Credit": 0.0
},
{
"ID": "831f1026-4b4c-49b1-9eee-4c5b71a5a6d8",
"Name": "Bank - Bank account via API change of instance 2",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 100.0000,
"Credit": 0.0
},
{
"ID": "3582c163-072d-4710-b557-b47b0f5f721a",
"Name": "Bank - Bank account via API change of instance",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 100.0000,
"Credit": 0.0
},
{
"ID": "50c35fbd-04cc-4796-bb84-5526f4d82806",
"Name": "Bank - Bank Account Via API 31-08-2018",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 100.0000,
"Credit": 0.0
},
{
"ID": "464da53a-11a6-4470-ac72-73be4ffd5404",
"Name": "Bank - Cloud POS Cash Register 23",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 3917.2000,
"Credit": 0.0
},
{
"ID": "a704e85e-010c-4cf0-b7be-43f0b0659c83",
"Name": "Bank - RCPOS Cash Register 3",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 700.0000,
"Credit": 0.0
},
{
"ID": "3daec792-0898-49a8-b808-283c7ea42faf",
"Name": "Bank - Bank Account",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 24.0000,
"Credit": 0.0
},
{
"ID": "65992190-1e26-4d25-a56d-1492d9f1f358",
"Name": "Bank - New Bank via app 5",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 8900000.0000,
"Credit": 0.0
},
{
"ID": "e51345d6-0f6b-4acf-a2d4-68e3d718983f",
"Name": "Bank - New Bank Account 4",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 20000.0000,
"Credit": 0.0
},
{
"ID": "0ce7d636-b67c-44ea-813b-a28ff9596ce6",
"Name": "Bank - New Bank Account 3",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 500000.0000,
"Credit": 0.0
},
{
"ID": "59b7107b-41e7-4a93-8a26-e5f1a008fa65",
"Name": "Bank - Bank updated via App",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 110.0000
},
{
"ID": "d129e51e-226e-41e9-907e-f18daf56869d",
"Name": "Bank - Tony Bank Account",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 4190.0000,
"Credit": 0.0
},
{
"ID": "c13ec354-9737-455c-bc34-d9024675d343",
"Name": "Bank - Bank 4",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 100.0000
},
{
"ID": "ec83afd2-4a3c-4d05-963c-df49c37f41f1",
"Name": "Bank - Cash",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 410.0000,
"Credit": 0.0
},
{
"ID": "b9cf6144-1900-41f1-9c28-6cf86d662496",
"Name": "Bank - Bank",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 83351.3400,
"Credit": 0.0
}
],
"CurrentAssets_AccountsReceivable": [
{
"ID": "8de07c43-7da6-4bcb-9413-b9c398d90e23",
"Name": "Accounts Receivable",
"Code": "1-1210",
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 610.9100,
"Credit": 0.0
}
],
"CurrentAssets_Other": [
{
"ID": "70fc511a-e48a-42b3-97eb-a29c7476908a",
"Name": "Finance Charges",
"Code": null,
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 4.5000
},
{
"ID": "4eda6b0a-a92e-4a00-a167-f272cd901b72",
"Name": "Current Assets",
"Code": "1-1100",
"Type": "Current asset",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 120.0000
}
],
"NonCurrentAssets_Fixed": [],
"NonCurrentAssets_Other": [],
"CurrentLiabilities_CreditCard": [
{
"ID": "c635a6d7-9357-4dbc-9bd5-73fa8523d5f7",
"Name": "Bank - Credit Card",
"Code": null,
"Type": "Current liability",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 1000.0000,
"Credit": 0.0
}
],
"CurrentLiabilities_AccountsPayable": [
{
"ID": "b6eecd74-4271-4d8c-92cd-eadea5e88124",
"Name": "Accounts Payable",
"Code": "2-1100",
"Type": "Current liability",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 2594.0000
}
],
"CurrentLiabilities_Other": [
{
"ID": "7a154c27-a810-45cc-a0c2-779a9ba3e7f4",
"Name": "Super Payable",
"Code": null,
"Type": "Current liability",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 1584.3400
},
{
"ID": "7ad51ffb-30b2-4788-b676-f0310c185c50",
"Name": "Payroll Payable",
"Code": null,
"Type": "Current liability",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 6476.0000
},
{
"ID": "fcd7f50c-bb54-41bc-a685-0bf92f936e13",
"Name": "GST Payable",
"Code": "2-1150",
"Type": "Current liability",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 0.0
},
{
"ID": "572d9053-1846-4d78-86fb-bc20250fd278",
"Name": "GST Collected",
"Code": "2-1155",
"Type": "Current liability",
"TaxCode": null,
"ParentID": "fcd7f50c-bb54-41bc-a685-0bf92f936e13",
"Debit": 0.0,
"Credit": 1283.3500
},
{
"ID": "e5502479-eb39-49e2-959b-5ca94d1c9c02",
"Name": "GST Paid",
"Code": "2-1160",
"Type": "Current liability",
"TaxCode": null,
"ParentID": "fcd7f50c-bb54-41bc-a685-0bf92f936e13",
"Debit": 347.9000,
"Credit": 0.0
},
{
"ID": "9725fff0-399f-4915-9160-e9f219b6ceb3",
"Name": "Payroll Liabilities",
"Code": "2-1200",
"Type": "Current liability",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 0.0
},
{
"ID": "9ee1ba89-fd40-4422-81cd-aebf213280c0",
"Name": "PAYG Withholding Payable",
"Code": "2-1220",
"Type": "Current liability",
"TaxCode": null,
"ParentID": "9725fff0-399f-4915-9160-e9f219b6ceb3",
"Debit": 0.0,
"Credit": 10878.0000
}
],
"NonCurrentLiabilities": [],
"Equity": [
{
"ID": "3b38544b-f4b3-4c2e-80ed-3b3734afe493",
"Name": "Opening Balance Equity",
"Code": "3-0100",
"Type": "Equity",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 0.0,
"Credit": 9525300.0000
},
{
"ID": "9fe2fc1b-2da4-49e0-9b6a-77b54ea49a52",
"Name": "Retained Earnings Surplus/(Accumulated Losses)",
"Code": "3-1000",
"Type": "Equity",
"TaxCode": null,
"ParentID": "00000000-0000-0000-0000-000000000000",
"Debit": 34487.5900,
"Credit": 0.0
}
]
},
"BookName": "Emon",
"DateGenerated": "2019-12-16T01:06:13.9073923+00:00",
"ReportName": "Trial balance"
}Details of each object
Data Field | Description | Data Type |
Income Array | This array contains all the transactions which are related to income. Each account is a entry as part of this array. | Array |
ID | The id of the account | GUID |
Name | The name of the account eg. Cash | Alphanumeric |
Code | The export code for the account | Alphanumeric |
Type | The type of the account eg: Income | GUID |
TaxCode | The tax code linked to the account | Alphanumeric |
ParentID | If this account is a subaccount, the GUID of the parent account for the subaccount | GUID |
Debit | The amount of debits on the account in the period specified | Numeric |
Credit | The amount of credits on the account in the period specified | Numeric |
OtherIncome Array | This array contains all the transactions which are related to Other Income. Each account is a entry as part of this array. Note - The data fields related to these transactions ar ethe same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc) | Array |
COGS Array | This array contains all the transactions which are related to COGS (Cost of Goods Sold). Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc) | Array |
Expenses Array | This array contains all the transactions which are related to Expenses. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference thsoe for further information (eg name ID, Code, Type etc). | Array |
Other Expenses | This array contains all the transactions which are related to Other Expenses. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc). | Array |
CurrentAssets_Bank | This array contains all the transactions related to Bank accounts as a current asset. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference thsoe for further information (eg name, ID, Code, Type etc). | Array |
CurrentAssets_AccountsReceivable | This array contains all the transactions related to Accounts Receivable as a current asset. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc). | Array |
CurrentAssets_Other | This array contains all the transactions related to Other transactions as a current asset. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc). | Array |
NonCurrentAssets_Fixed | This array contains all the transactions related to Fixed Assets as a non current asset. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc). | Array |
NonCurrentAssets_Other | This array contains all the transactions related to Other transactions as a non current asset. Each account is a entry as part of thsi array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference thsoe for further information (eg name, ID, Code, Type etc). | Array |
CurrentLiabilities_CreditCard | This array contains all the transactions related to Credit Card transactions as a current liability. Each account is a entry as part of this array. Note - The data fields related to these transactions are the samae as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc) | Array |
CurrentLiabilities_AccountsPayable | This array contains all the transactions related to Accounts Payable transactions as a current liability. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc) | Array |
CurrentLiabilities_Other | This array contains all the transactions related to the Other transactions as a current liability. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference thsoe for further information (eg name, ID, Code, Type etc) | Array |
NonCurrentLiabilities | This array contains all the transactions related to Non Current LIabilities. Each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc) | Array |
Equity | This array contains all the transactions related to Equity. each account is a entry as part of this array. Note - The data fields related to these transactions are the same as the Income Array type. Please reference those for further information (eg name, ID, Code, Type etc) | Array |
BookName | The name of the Reckon One book this data is from | Alphanumeric |
DateGenerated | The time this report was generated by the API | Date/Time |
ReportName | The name of the report | Alphanumeric |
