Jump to content

Uploading Transactions to a Custom Bank Account


 Share

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

 

image.png.80213a9b7c8ab09d48e1b62fcfb0fefc.png

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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,

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
 Share

×
×
  • Create New...