# Business General Ledger Template

If you are new to the Bkper Add-on for Google Sheets, the Business General Ledger Template is a great starting point. It pairs a Bkper Book with a simple Chart of Accounts and a Google Sheet report that fetches data directly from the Book.

- [The Bkper Book Template](https://app.bkper.com/b/#transactions:bookId=agtzfmJrcGVyLWhyZHITCxIGTGVkZ2VyGICAgKD_4bMLDA&viewer=true)
- [The Google Sheet Template](https://docs.google.com/spreadsheets/d/1icR8z8F3RSBeedfMbNE4-Q2FZvxyDhZeSrHuSXvPXr8/edit?gid=868176831)

## Copy the Book Template

Open the Bkper Book Template and click **Copy book** to create your own copy.

![The current Bkper General Ledger template with the Copy book button and sample transactions](https://bkper.com/docs/_astro/general-ledger-template.DT1bVRDY.png)

## Copy the Sheet Template

Open the Google Sheet Template and select **File > Make a copy** to save it to your own Google Drive.

![Make a copy of the Google Sheet Template](https://bkper.com/docs/_astro/general-ledger-template-4.BxgMGWKN.png)

> **Note**
> Select **My Drive** in the copy dialog to save the copy.
![Select My Drive in the Google Sheets copy dialog](https://bkper.com/docs/_astro/general-ledger-template-5.yx1C0y0E.png)

## Connect the Sheet to Your Book

Once you have both copies, retrieve the [bookId](https://bkper.com/docs/guides/using-bkper/books.md#bookid) from **your copy** of the Book Template. Then open the **Instructions** tab in your copy of the Sheet and replace the bookId with your own.

![Replacing the bookId on the Instructions tab of the Google Sheet](https://bkper.com/docs/_astro/general-ledger-template-7.sIfowkw2.png)

## Record a Transaction and Explore

Record a [Transaction](https://bkper.com/docs/core-concepts.md#transactions) in your Book to generate some data. Then change the **year** on the Instructions tab and explore the other tabs to see your financial data flowing into the report.

![Changing the year on the Instructions tab of the Google Sheet Template](https://bkper.com/docs/_astro/general-ledger-template-8.C9bm8rTT.png)

## Important Notes

> **Caution**
> When you copy a Sheet with Bkper Functions, it may take some time (up to 24 hours) for the cache to update and recognize the formulas. You may initially see **#ERROR!** in cells with Bkper functions. Closing and reopening the Sheet can speed up the process. Eventually the errors disappear and balance values from your Book appear.
If you change the name of the **Total Equity** Group in your copy of the Book, you must also update that name in the query used by the Bkper Function in your copy of the Sheet report.

![Bkper Function referencing the Total Equity group name in the Sheet](https://bkper.com/docs/_astro/general-ledger-template-9.DL75qK2t.png)