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

Reports

/accountEnquiry

/false

POST

Retrieve all transactions from the book based on the parameters specified in the POST request

 

Portal

AU/NZ/UK

Core

Reports

/profitLoss

POST

Retrieve the profit and loss report from the book based on the parameters specified in the POST request

1.8

Portal

AU/NZ/UK

Core

Reports

/balanceSheet

POST

Retrieve the balance sheet report from the book based on the parameters specified in the POST request

1.10

Portal

AU/NZ/UK

Core

Reports

/trialbalance

POST

Retrieve the trial balance report from a book based on the parameters specified in the POST request

1.9

Portal

AU/NZ/UK

Valid Period Types

Period type is required to be sent with each Report payload.

  1. ThisMonth,
  2. ThisQuarter,
  3. ThisYear,
  4. ThisYearToDate,
  5. ThisMonthLastYear,
  6. ThisQuarterLastYear,
  7. LastMonth, LastQuarter,
  8. LastYear,
  9. LastYearToDate,
  10. Last3Months,
  11. Last6Months,
  12. Last12Months,
  13. AsAtToday,
  14. AsAtDate,
  15. This2MonthPeriod,
  16. This6MonthPeriod,
  17. Last2MonthPeriod,
  18. Last6MonthPeriod,
  19. AsAtEndOfThisFinancialYear,
  20. AsAtEndOfLastFinancialYear,
  21. AllDates,
  22. 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:

  1. accountenquiry
  2. trialbalance
  3. profitloss
  4. balancesheet
  5. top10suppliers
  6. top10customers
  7. ledgertransactions
  8. 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

  • Cash basis = 1
  • Accrual basis = 2

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

  • JNL = Journal
  • REC = Receipt
  • CAN = Customer Adjustment Note
  • BILL=Bill
  • SAN=Supplier
  • Adjustment Note
  • PAY=Payment

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

 

How did we do?

Activity Statements

Budgets ( Reckon One API)

Related Articles

Reports - Reckon One
Reports - Payroll App
Reckon Accounts Desktop: Balance Sheet Summary Report displays the heading "Summary Balance Sheet"
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)