How to sync transactions to BGL

Guide to syncing transactions to BGL SF360 and BGL SI360

Updated over a week ago

We'll show you how to sync all your transactions from Syla into BGL.

Note: The BGL sync feature is only available on Private Wealth and Private Wealth+ plans. It allows syncing transaction data from Syla to BGL Simple Fund 360 and BGL Simple Invest 360.

Note: This article uses examples for Simple Fund 360, however, the process is near-identical for Simple Invest 360.

Before syncing to BGL

Reconcile all your transaction data

It's recommended to get everything imported accurately into Syla before syncing transaction data across to BGL. If you need to make any edits or adjustments, it will be much simpler to do in Syla.

Here's what you need to do:

  1. Import all Data Sources for the entity.

  2. Ensure the balances for each data source are correct.

  3. Check that there are no negative balances or missing data.

Once you're happy with the data, you can move to the next step.

Get your BGL Account ID

You can get your BGL Account ID from the Account Settings > General page in Syla. This will be used later on to setup the feed in BGL.

Setting up the file in BGL

You should first set up the entity in BGL as normal.

Entity Settings

Ensure the Date Formed for the entity is earlier than the earliest transaction in Syla, as BGL will not import transactions that are earlier than the Date Formed.

Create a bank account

Setup a new bank account that will be used for the crypto activity. All AUD transactions will go to this cash account. You only need to create a single bank account in BGL regardless of how many data sources exist in Syla.

Connect BGL to Syla

You now need to setup the feed in BGL.

  1. In the left navbar, click Connect and select Feed Management.

  2. Go to the Wraps and Platforms section and click Setup.

  3. In the Feed Provider dropdown, select Syla.

  4. In the Account ID enter the BGL Account ID that you copied earlier from the Account Settings > General page in Syla.

  5. In Bank Account, select the previously created bank account.

  6. Click Save.

The connection between Syla and BGL has now been established.

Sync transactions from Syla to BGL

Now that the connection between Syla and BGL is established, you can sync transactions on-demand.

  1. Go to the Tax Reports page in Syla.

  2. Select the Financial Year that you would like to sync transactions for.

    Important: Start with the oldest financial year first.

  3. Click the Sync button.

Tip: It's important that you start syncing transactions from the earliest financial year first, otherwise the transactions will arrive to BGL out of order, and BGL will ignore some data due to the resulting negative balances. It's also recommended to wait for each financial year to sync across, before doing the next one.

Once you press Sync, all transactions will be sent from Syla to BGL. It usually takes a minute or so for BGL to process the transactions and import them, but it can take longer in some cases.

You can sync as often as you like to keep the transactions up to date in BGL. Only new or updated transactions from Syla will be synced, so you won't get any duplicates.

Enter manual adjustments for certain transactions

Almost all your crypto transactions will be synced from Syla to BGL, but there are a few transaction types that will need a manual adjustment.

You’ll need to do a manual journal for the following transactions:

  • Foreign Currency Gains or Losses

  • Other Expenses

Fortunately, you only need to create a single manual journal to get each of these into BGL.

  1. In Syla, download a Crypto Tax Report from the Tax Reports page.

  2. Check the Crypto Tax Report to see if there are any Foreign Currency Gains or Losses. If there are, you’ll need to create a manual journal in BGL to account for it.

  3. Check the Crypto Tax Report to see if there are any Other Expenses listed. If there are, you’ll need to create a manual journal in BGL for the expense item.

Reviewing synced data

You can confirm completeness of all transactions by checking a few reports in BGL.

Review the Investment Summary Report

Complete these steps as a review to confirm the correct final balances and market values have been achieved.

  1. Create an Investment Summary Report in BGL.

  2. Check that the quantities of the crypto closing balances shown on the Investment Summary Report match what is shown in Syla’s Crypto Tax Report.

    1. You should also check that the quantity in the closing balances are matching what is shown on the client’s account statements from the digital currency exchange.

  3. Check that the closing market values shown on the report are reasonably close to what is shown in Syla.

    1. the market values won’t be exactly the same, as the crypto pricing in BGL uses a different valuation source to Syla.

    2. You should also confirm that the market values appear reasonable, just in case one of the crypto ticker symbols has been translated across incorrectly.

Fixing missing Market Values

Although all the major cryptocurrencies are supported in both Syla and BGL, it’s possible that the market values for some of the less known cryptocurrencies to be absent.

Missing market values are an easy problem to solve in BGL:

  1. Review the BGL Investment Summary Report for any market price that says 0.0000. As this indicates that a market value is missing.

  2. In Syla’s Crypto Tax Report, there is a Closing Balances section that includes the Closing Balance and Market Value of each crypto asset on 30 June.

  3. Calculate the market price for the asset by dividing the Market Value by the closing balance quantity.

  4. Follow the instructions from BGL to add a manual price reference.

As a final check, you can compare the total market value of the portfolio in BGL against what is shown in Syla's Crypto Tax Report.

Note: The market values for closing balances in the BGL financial statements are supplied by BGL, as such, they may differ from the market values shown in Syla. Some price references for less common assets are missing from BGL, and will need to be manually entered.

Review the Investment Income Report

Complete these steps to confirm that all income sources have been correctly reported:

  1. Create an Investment Income Report in BGL.

  2. Check that the Other Income shown in Syla's Crypto Tax Report is present in the Investment Income Report in BGL.

  3. Confirm that the income totals match up.

Review the General Ledger

Complete these steps to confirm that there is no net movement in the data clearing accounts, as you don’t want these to appear in the final SMSF statements.

  1. Prepare the General Ledger in BGL.

  2. Check if there are any non-zero balance in the data clearing accounts related to the crypto activity.

  3. If there is a net amount, then you should start by reconciling any cash movements between the SMSFs bank account and the digital currency exchange.

  4. Finally, you can create a manual journal to offset the data clearing accounts to zero.

Reach out to our team if you need help

If you encounter any issues, please reach out to our team at Syla.

Did this answer your question?