Bill Credit Notes

A bill credit note is issued by a vendor to record credit.

Overview

A Bill Credit Note is a financial transaction representing a refund or credit of payment or part of a payment for goods or services that have been bought from a Vendor. From the Bill Credit Notes endpoint, you can retrieve a list of all bill credit notes for a specified business. See Bill Credit Notes endpoint for more details.

Data Model

Field

Type

Description

id

string

Identifier for the bill credit notes, unique to the business in the accounting service provider.

vendorRef

Reference Types

Vendor that issued the bill credit note.

postedDate
sortable

string
See Date

Date of the bill credit note as recorded in the accounting service provider.

allocatedOnDate
sortable

string
See Date

Date the bill credit note was fully refunded or allocated.

currencyRef

Reference Types

Currency of the bill credit note.

Pushing data will fail if the business has not enabled or does not support multiple currency. Leaving this blank would default to the business' default currency.

currencyRate

decimal

Rate between the currency of the bill credit note and the base currency of the business. Not applicable when multi-currency is not supported.

lines

array

An array of bill credit note lines.

status
sortable, filterable

string

Current status of a bill credit note.

subTotal

decimal

Value of the bill credit note, including discounts and excluding tax.

taxAmount

decimal

Any tax applied to the bill credit note amount.

totalAmount
sortable, filterable

decimal

Amount of the bill credit note, inclusive of tax.

remainingCredit
sortable, filterable

decimal

Amount of the bill credit note that is still outstanding.

discountPercentage

decimal

Percentage rate of any discount applied to the bill credit note.

totalDiscount

decimal

Total value of any discounts applied.

memo

string

User-friendly reference for the bill credit note.

payments

array

An array of bill credit note payments.

sourceModifiedData

string
See Date

Date the record was last changed in the accounting service provider.

Lines

Field

Type

Description

description

string

Friendly name of the goods or services received.

unitAmount

decimal

Price of each unit of goods or services.

quantity

decimal

Number of units of goods or services.

discountAmount

decimal

Numerical value of any discounts applied.

discountPercentage

decimal

Percentage rate (from 0 to 100) of any discounts applied to the unit amount.

subTotal

decimal

Amount of the line, inclusive of discounts but exclusive of tax.

taxAmount

decimal

Amount of tax for the line.

totalAmount

decimal

Total amount of the line, inclusive of discounts and tax.

accountRef

Reference Types

Reference to the account to which the line item is linked to.

taxRateRef

Reference Types

Reference to the tax rate to which the line item is linked to.

inventoryRef

Reference Types

Reference to the product or inventory item to which the line item is linked to.

trackingCategoryRef

Reference Types

Reference to the tracking category to which the line item is linked to.

Payments

Field

Type

Description

amount

decimal

Payment amount in the currency of the bill credit note.

paymentId

string

Identifier of the bill payments data type.

date

string
See Date.

Date of the payment.

Bill Credit Note Status

  • open - Bill Credit Note is no longer a draft. It has been processed and/or sent to the vendor. In this state, it will impact the ledger.
  • partiallyPaid - The remaining credit against the bill credit note is positive, but less than the total bill credit note amount.
  • paid - Bill Credit Note has been applied or refunded in full.
  • void - A Bill Credit Note can become void by being deleted, refunded, written off, or cancelled.
  • draft - Bill Credit Note is yet to be authorized and sent by the vendor, and will not be used in any reports. It may contain incomplete line items.
  • unknown - Railz was not able to recognize the status of the bill credit note. This can be due to missing values in the accounting service provider or unavailable in the data we received.

Example Data

{
  "data":
  [
    {
      "id": "1",
      "vendorRef":
      {
        "id": "1",
        "name": "Home Depot"
      },
      "purchaseOrderRef":
      {
        "id": "15",
        "purchaseOrderNumber": "1500"
      },
      "postedDate": "2021-03-09T10:18:29.985Z",
      "dueDate": "2021-03-09T10:18:29.985Z",
      "currencyRef":
      {
        "id": "CAD",
        "name": "Canadian Dollar"
      },
      "currencyRate": 1.13,
      "lines":
      [
        {
          "description": "Services rendered.",
          "unitAmount": 100.5,
          "quantity": 3,
          "discountAmount": 0,
          "subTotal": 301.5,
          "taxAmount": 20.5,
          "totalAmount": 322,
          "discountPercentage": 10.5,
          "taxRateRef":
          {
            "id": "1",
            "name": "HST",
            "effectiveTaxRate": 13
          },
          "inventoryRef":
          {
            "id": "1",
            "name": "Digital Services"
          },
          "accountRef":
          {
            "id": "145",
            "name": "Depreciation Expense"
          }
        }
      ],
      "status": "open",
      "subTotal": 301.5,
      "taxAmount": 20.5,
      "totalAmount": 322,
      "amountDue": 322,
      "memo": "Example bill memo.",
      "payments":
      [
        {
          "amount": 50.5,
          "paymentId": "50",
          "date": "2021-03-09T10:18:29.985Z"
        }
      ],
      "sourceModifiedDate": "2021-03-09T10:18:29.985Z"
    }
  ]
}

Did this page help you?