Home › Knowledgebase › KB-1646

How to Synchronise Sensitive Bank Records to SharePoint Online Without Exposing the Entire Site

Summary

This guide helps you troubleshoot and resolve: How to Synchronise Sensitive Bank Records to SharePoint Online Without Exposing the Entire Site. Follow the steps below to fix the issue.

Quick Tip: Need immediate assistance? 💻 Open a Ticket

Common Causes

Accountancy and bookkeeping practices frequently need to store digital bank statements, transaction logs, and BAS preparation files in SharePoint Online. Because these records are highly sensitive, they should not sit in a general document library where inherited permissions grant broad access to all staff. This article explains how to synchronise bank records from a local server or NAS to SharePoint Online and apply unique permissions to a dedicated document library so that only authorised users—such as the principal accountant—can view or edit financial data.

Quick Fix Steps

  1. Create a dedicated document library in SharePoint Online for banking records.
  2. Stop permission inheritance on the new library.
  3. Remove broad access groups and grant permissions only to authorised users.
  4. Configure ongoing synchronisation between the local NAS and SharePoint Online.
  5. Verify that unauthorised users cannot access the library using a test account.

Detailed Instructions

1. Create a Dedicated Document Library

  1. Open your SharePoint site in a web browser.
  2. Select Home from the left navigation, then choose New.
  3. Click Document library.
  4. Enter a clear name such as Banking Records or Client Bank Statements.
  5. Select Create.

Using a separate library rather than a folder inside a general library makes it easier to manage unique permissions and reduces the risk of accidental access.

2. Break Permission Inheritance

  1. Open the new Banking Records library.
  2. Select the Settings gear icon in the top-right corner, then choose Library settings.
  3. Under Permissions and Management, select Permissions for this document library.
  4. On the ribbon, select Stop Inheriting Permissions.
  5. When the confirmation prompt appears, select OK.

Breaking inheritance removes the library from the parent site permissions. Any users who previously had access through the site will no longer be able to enter this library unless you explicitly grant them access.

3. Remove Broad Access and Grant Authorised Users

  1. With the library permissions page open, select Grant Permissions.
  2. Enter the names or email addresses of users who require access, such as the principal accountant and senior bookkeeper.
  3. Choose the appropriate permission level—typically Edit or Full Control—then select Share.
  4. Review the list of existing users and groups. Select any broad groups such as All Staff, Members, or Visitors, then choose Remove User Permissions.
  5. Select OK to confirm removal.

Grant permissions to individual users or a dedicated security group rather than to Everyone except external users.

4. Configure Ongoing Synchronisation

  1. Install the OneDrive sync client on the workstation or server that hosts the local bank records.
  2. Sign in with an authorised account that has access to the Banking Records library.
  3. Navigate to the SharePoint Banking Records library in your browser.
  4. Select Sync from the command bar.
  5. Follow the prompts to synchronise the library to a local folder on the NAS or server.
  6. Move or copy bank statements and transaction logs into the local synced folder.
  7. Wait for the sync client to upload changes to SharePoint Online.

5. Verify Access Restrictions

  1. Sign in to a workstation using a non-admin test user account that should not have access to banking records.
  2. Navigate to the SharePoint site and attempt to open the Banking Records library.
  3. Confirm that the user receives an access denied message or cannot see the library.
  4. Sign in with an authorised account and confirm that the files open correctly.

Compliance Considerations for Bank Records

Storing sensitive financial data in SharePoint Online requires additional governance to meet accountancy compliance standards and BAS preparation requirements.

Troubleshooting

Users Can Still Access the Library After Inheritance Is Broken

Authorised Users Receive Access Denied

Synchronisation Paused or Failing

Files Do Not Appear After Synchronisation

If you need assistance configuring permissions or synchronisation for your banking records, Open a Ticket and our Brisbane team will get it sorted.

Still Having Issues?

Need more help? If the issue persists after trying these steps, please open a support ticket and our team will assist you.

💻 Open a Ticket