The Bkper add-on for Google Sheets lets you record transactions from Google Sheets and fetch Balance Values and Transactions with Bkper Sheets Functions from your book into Google Sheets. So, you centralize financial data on Bkper to create a balance sheet and P&L statements on Google Sheets.
Install from the Gooble Workspace Marketplace with one click on the install button on the top right, then:
The first time you access the Add-on you must authorize the access from your Google Sheet to Bkper for your user account. Once installed and authorized, the Add-on for Bkper and the Bkper Sheets Formulas will be available on all your Google Sheets.