Uploading Transactions to a Custom Bank Account

[Aytac TOKATLI]

Hi,

I need to upload transactions to custom defined bank account through API. For manually uploading, each time I need to modify the reports which I collect, instead of this, I can directly transfer from internal systems to Sage Accounting. Is there any API for uploading this data. When I looked at the predefined API, I could not see, or I did not understand one of them is suitable for this aim. (and this api call will be a private connection) Do you know any api which can handle this process?

Thank you so much

[Steel, Mark]

Hi, thank you for your question.

The Sage Business Cloud Accounting API provides the ability to create many different types of transactions.

You don't state that any of the transactions are associated with contacts of the business so for that reason you would need to POST the transactions via the other_payments endpoint.

You can find further information relating to receipts and payments in our API Reference.

Thanks

Mark

[Aytac TOKATLI]

Thank you so much, it is not directly connected to any customer, for example we have multiple ebay stores, and we want to import transactions in each store. 

Based on this, I created a bank for ebay,  relevant to this bank, a ledger account is created, I am assigning bank and ledger account to other payments end point. But the system is giving ledger account is invalid error.

 

{
    "other_payment": {
        "transaction_type_id": "OTHER_RECEIPT",
        "payment_method_id":"CREDIT_DEBIT",
        "bank_account_id": "681587433c82410a89f3f4494b657174",
        "date": "2021-10-29",
        "total_amount": 10,
        "payment_lines": [
            {
                "ledger_account_id": "b75e0d96c7f34b73bf3212b419878c1b",
                "total_amount": 10.0,
                "tax_rate_id": "GB_STANDARD"
            }
        ]
    }
}

 

What can be wrong here? Do you have any idea?

Thank you so much

[Steel, Mark]

I'm pleased you've been able to make some progress.

Could you make the following requests please and provide the response here?

GET https://api.accounting.sage.com/v3.1/bank_accounts/681587433c82410a89f3f4494b657174

GET https://api.accounting.sage.com/v3.1/ledger_accounts/b75e0d96c7f34b73bf3212b419878c1b

Thanks

Mark
 

[Aytac TOKATLI]

I finally solved the issue, it is recording transactions. Thank you so much.

But I was expecting it will be seen on Banking screen blue transactions area, but instead of it, this api is directly processing payment.

We would like to see in transactions area to match with printed invoices. Is that possible?

Thank you so much

 

[Steel, Mark]

Pleased you've been able to find the solution. 

I'm not sure I fully understand what you mean. The transactions area of the screen shot you have provided is for imported bank transactions or transactions incoming from a connected bank feed?

To clarify, you would like to recreate the sales_invoice as per ebay in SBCA and then allocate the payment against the invoice?

Are you using a Payment provider such as Paypal for your ebay shop?

Thanks

Mark

[Aytac TOKATLI]

Payments are directly send to bank account as a bulk sum per week. Paypal is not being used any more.

Shortly our flow for paypal like this,

- whenever a transaction occurs, it is automatically visible at blue transactions area in Banking main page

- invoice is being printed with dispatch of the product

- after that we are matching transaction in paypal with invoice from transaction area which is accessed clicking blue transactions area in banking section

we want to establish same behaviour for our shops in etsy and ebay.

You have the option to import manually transactions into each bank. But it is so much time consuming when you have multiple shops. And 40+ movement per day per shop.

[Steel, Mark]

If you're receiving payouts from 3rd party providers they are usually the net amount of Payment amount - Payment provider fees. They wouldn't cover the amount of the outstanding invoices. How do you intend to account for transaction/ebay fees? 

We've recently created the following guide which goes into a little more detail on the accounting side. Let me know if this flow would be the flow you are working towards.

Thanks

Mark

[Aytac TOKATLI]

Thank you so much, I read once, I will read more in detail.

[Aytac TOKATLI]

In ideal world, I mean without any customer issue, the method in the guide is so good to automate every aspect, but we have already 2 accountant, and we wish to use your application as a management summary day by day for now. And if we think 3d party payment processor perspective, in normal banks how customer payments and bank charges are being processed, our aim is making everything like that, we know each transaction in ebay produces a fee which will be deducted from final payment.

We can store transactions relevant to customer orders in a batch, and transactions to relevant to fees in another batch, for refunds and cancellations again same principle, it does not needs to work immediately, but accountant needs to review each case, and each transaction which are occurring ebay -  etsy and amozon will be assigned to departments and cost centres, and this can not be easily automatable process.

Is there any other way, as I denoted before adding not as a finalized transaction, instead of it, we want it to wait internal accountant process.

Thank you

[Steel, Mark]

HI

You could create each of the transactions as a sales_invoice artefact. They would be seen in the sales summary and left unpaid for your accountant to then process.

You would however need to associate each sales_invoice against a customer contact. 

Thanks

Mark 

[Aytac TOKATLI]

Actually, it is so disappointing, manual transaction upload not working, it is giving generic error as "Column headers missing" as you can see column headers already exist.

And we can not upload transactions via API as well. We are being forced to use your non-working transaction upload section.

Date,Description,Money in,Money out
31/10/2021,Order:Customer 1 Surname,15.99,
31/10/2021,Order:Customer 2 Surname,18,
30/10/2021,Other fee:Ad Fee Standard,,0.64
30/10/2021,Order:Customer 3 Surname,11.99,

[Aytac TOKATLI]

The problem is amount of lines, you are not allowing more than 80-100 lines I think, in a month we have more than 160 transactions in a shop. I think using this software is worthless while could not upload data as bulk. This leads to human error. Is this software not suitable for medium businesses?

[Aytac TOKATLI]

OFX file format not working either: "invalid date format"

[Aytac TOKATLI]

Please delete this topic, I will handle somehow.

[Steel, Mark]

Thanks for your feedback.

I believe we're talking at cross purposes. This area of support is for the applications programming interface which is not effected by any form of transactional restriction.

The import you mention is core user functionality. Issues and learning around usage can be discussed in the customer help centre which for UK users can be found at https://my.sage.co.uk/public/help.aspx#/contact?locale=uk&type=customer&product=sagebusinesscloudaccounting

Alternatively, there are third party solutions that would offer the functionality you seek and can be found in our Sage Marketplace.

Thanks

Mark