Bank Feeds

NEW!

With bank feeds, you can access transaction records for bank reconciliation directly using Sage Cloud Services, or you can provide your own transaction records as XML elements.

Bank feeds are currently supported for checking account reconciliation.

When you create a bank feed, the bank transactions become available for matching against existing transactions during reconciliation.

Note: In the UI, transactions available for matching are found under Cash Management > All > Reconciliation > Bank.

List Bank Feeds

query

List the record number and bank account ID for each bank feed for the given date:

<query>
    <object>BANKACCTTXNFEED</object>
    <select>
        <field>RECORDNO</field>
        <field>FINANCIALENTITY</field>
    </select>
    <filter>
        <equalto>
            <field>FEEDDATE</field>
            <value>01-27-2020</value>
        </equalto>
    </filter>
</query>

Parameters

Name Required Type Description
object Required string Use BANKACCTTXNFEED
select Required sequence One or more field names and an optional aggregate function such as count or sum. Returning all fields is not supported.
filter Optional object Query filter expression. Check the value of a single field using operators such as equalto/like, or multiple fields using and/or. Query fields on related objects using the dot operator (for example, VENDOR.CREDITLIMIT on APBILL).
orderby Optional object Provide an order element with a field name and choose an ascending or descending sort order, for example:
<order>
        <field>RECORDNO</field>
        <descending/>
</order>
options Optional object Set the caseinsensitive element to true for a case-insensitive query:
    <caseinsensitive>true</caseinsensitive>
In a multi-entity company, set the showprivate element to true to query data in private entities:
   <showprivate>true</showprivate>
pagesize Optional integer Custom page size between 1 and 2000 items (Default: 100)
offset Optional integer Point at which to start indexing into records (Default: 0)
docparid Optional string Document type, such as Sales Order, Purchase Order, or Inventory Transfer

List Bank Feeds (Legacy)

readByQuery

<readByQuery>
    <object>BANKACCTTXNFEED</object>
    <fields>*</fields>
    <query/>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use BANKACCTTXNFEED
fields Optional string Comma-separated list of fields on the object to list. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.
query Required string SQL-like query based on fields on the object. The following operators are supported: <, >, >=, <=, =, like, not like, in, not in, IS NOT NULL, IS NULL, AND, OR. Illegal XML characters must be properly encoded, and single quotes must be escaped with backslashes ('Jane\'s Deli'). Joins are not supported.
pagesize Optional integer Custom page size between 1 and 1000 items (Default: 100)

Get Bank Feed

read

<read>
    <object>BANKACCTTXNFEED</object>
    <keys>91</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use BANKACCTTXNFEED
keys Required string Bank feed RECORDNO to get
fields Optional string Comma-separated list of fields on the object to get. For best performance and predictability, limit the number of fields. To return all fields, omit the element or provide * for the value.

Create Bank Feed

You create a bank feed using one of the following approaches:

  • Set the feed type to onl to fetch transactions from a bank subscribed to Sage Cloud Services.
  • Set the feed type to xml and provide XML bank transactions directly in the create call.

create

Create a bank feed by providing transactions as XML elements:

<create>
    <BANKACCTTXNFEED>
        <FINANCIALENTITY>BOV</FINANCIALENTITY>
        <FEEDDATE>05/15/2020</FEEDDATE>
        <FEEDTYPE>xml</FEEDTYPE>
        <BANKACCTTXNRECORDS>
            <BANKACCTTXNRECORD>
                <POSTINGDATE>04/09/2020</POSTINGDATE>
                <TRANSACTIONTYPE>withdrawal</TRANSACTIONTYPE>
                <DOCTYPE>Check</DOCTYPE>
                <DOCNO>198</DOCNO>
                <AMOUNT>-184.00</AMOUNT>
                <DESCRIPTION>Office supplies</DESCRIPTION>
            </BANKACCTTXNRECORD>
            <BANKACCTTXNRECORD>
                <POSTINGDATE>04/09/2020</POSTINGDATE>
                <TRANSACTIONTYPE>withdrawal</TRANSACTIONTYPE>
                <DOCTYPE>Check</DOCTYPE>
                <DOCNO>222</DOCNO>
                <AMOUNT>-211.14</AMOUNT>
                <DESCRIPTION>Computer service call</DESCRIPTION>
            </BANKACCTTXNRECORD>
            <BANKACCTTXNRECORD>
                <POSTINGDATE>04/17/2020</POSTINGDATE>
                <TRANSACTIONTYPE>deposit</TRANSACTIONTYPE>
                <DOCTYPE>Check</DOCTYPE>
                <DOCNO>220</DOCNO>
                <AMOUNT>2000.00</AMOUNT>
                <DESCRIPTION>From account CH to account BOV</DESCRIPTION>
            </BANKACCTTXNRECORD>
        </BANKACCTTXNRECORDS>
    </BANKACCTTXNFEED>
</create>

Create a bank feed by fetching transactions from the Sage Intacct banking cloud:

<create>
    <BANKACCTTXNFEED>
        <FINANCIALENTITY>BOA</FINANCIALENTITY>
        <FEEDDATE>05/15/2020</FEEDDATE>
        <FEEDTYPE>onl</FEEDTYPE>
    </BANKACCTTXNFEED>
</create>

Parameters

Name Required Type Description
BANKACCTTXNFEED Required object Object to create

BANKACCTTXNFEED

Name Required Type Description
FINANCIALENTITY Required string Bank account ID
FEEDDATE Required Date Feed date in format mm/dd/yyyy
FEEDTYPE Required string Feed type to create. Use xml to provide the transactions in XML format, or use onl to use online bank feeds through Sage Cloud Services.
FILENAME Optional string File name that displays in the UI when using automatch with review (AutomatchReview) as the reconciliation mode.
BANKACCTTXNRECORDS Optional BANKACCTTXNRECORD[1..n] Bank account transaction records. Required only if the feed type is xml.

BANKACCTTXNRECORD

Name Required Type Description
TRANSACTIONID Optional integer Transaction ID of the bank feed transaction. This is available only for banking cloud transactions.
POSTINGDATE Optional date Transaction posting date in format mm/dd/yyyy
TRANSACTIONTYPE Required string Transaction type. Use withdrawal or deposit.
DOCTYPE Optional string Document type
DOCNO Optional string Document number
PAYEE Optional string Payee
AMOUNT Required currency Transaction amount. For a withdrawal, use a negative number.
DESCRIPTION Optional string Description
CURRENCY Optional string Currency

Delete Bank Feed

You can delete a bank feed object created with a feed type of xml if the transactions have not yet been reconciled. You cannot delete an online bank feed from Sage Cloud Services.

<delete>
    <object>BANKACCTTXNFEED</object>
    <keys>91</keys>
</delete>

Parameters

Name Required Type Description
object Required string Use BANKACCTTXNFEED
keys Required string Record number of the xml bank feed

Provide feedback