Overview
The General Ledger report gives you all the transactions for all accounts within a selected Date Range.
To generate a General Ledger report, simply go to Reports and click on General Ledger.
This will take you to the General Ledger report page where you will be able to enter the Date Range that you would like to run the report for. Usually this will be for a specific period, such as the Current Financial Year, or a Tax Reporting period. This is why there are quick selection options available in the Date Range drop down.
You can select from one of the following Date Range options:
- Last 7 Days
- Last 30 Days
- This Month
- Last Month
- This Financial Year
- Last Financial Year
- Custom - The custom range allows you to specify Dates for the start and end dates of the report
You can also specify a particular Account if you wish to only look at one or a few Accounts at a time. This will help speed up the report as well as reduce the amount of data that is presented. This can help reduce the amount of scrolling required to review the report. If you leave the this account selection field empty then you will run the report for all Accounts.
Note that Accounts will only show transactions if they exist. In other words, if an Account doesn't appear then there are no transactions for this Account for this Date Range.
If you're expecting something then double check the Date Range or the Account. It is possible that the transaction you're expecting has been allocated to the wrong account.
The General Ledger has been set up so that each Account is colour Coded. This helps identify the various account types when scrolling through what can be a long report.
You can export the General Ledger report to a CSV file for further manipulation or analysis in a spreadsheet.
The following fields are included on the General Ledger report:
- ID
This is the ID that the transaction is associated to. e.g. if a transaction represents a line item from an Invoice then the Id will be the Number (ID) of that Invoice. - Date
This is the date that the transaction is recorded. e.g. if a transaction is a line item from an expense this Date will be the date of the Expense - Description
This is the description of the document that the transaction relates to. e.g. if this transactions if from an Invoice then this will be the Invoice Title - Debit
- Credit
- Balance
The Balance column shows you the balance based on the Opening Balance plus or minus any transactions that have been entered for this Account since the beginning of time (Note that the beginning of time in Beeswax Terms is anything after 2000).
Let's look at each Role
AKA: The Boss
This is the Owner of the Account and more often than not they are also the Owner of the business. The business Owner should obviously see everything so of course they have Full Access to all parts of the application but importantly they are unique in that they are the ones who are responsible for managing the Beeswax Subscription and associated Plan.
It's likely they have a business partner or a dedicated senior staff member who needs to be able to see and do all the same things that the Owner can. That's what the Super
Admin Role which we get to next.
Business Partner or a Senior Employee
The Super Admin User also has Full Access to everything however they don’t have access to the Subscription but that’s all. These are usually Partners in the business or Senior Employees who need to see and control everything in the Business. Warts and all!
Production Manager or Account Manager
The Manager Role is generally the person who takes care of the day to day running of Projects, and oversees Tasks.
This Role would be for a Production Manager, Studio Manager or Account Manager for instance.
They generally don’t get involved in Payroll financial reports and as such are not expected to know anything about Accounting or Tax related matters.
Of course these things aren’t necessarily that difficult to understand, however, so as to avoid the potential pitfalls associated with incorrectly allocated transaction Accounts and / or Taxes we have chosen to limit this Users access and control over such things.
So, while Manager can create Quotes, Expenses and Invoices, they can’t change the Transaction Account and Tax when working on any of these documents. While Managers can create Quotes, Expenses and Invoices, they can’t change the Transaction Account allocation nor the Tax Allocation when the are preparing any
These are defined by the Items that make up these documents and are therefore meant to be set up specifically by someone with this knowledge such as your Bookkeeper or Accountant.
Your Accountant (obviously) or your Bookkeeper
This Accountant Role is obviously for the Accountant or Bookkeeper who need access to all things Money. They essentially have full access to the entire system with the exception of being able to manage the subscription.
A User who primarily works on Tasks
This Accountant Role is obviously for the Accountant or Bookkeeper who need access to all things Money. They essentially have full access to the entire system with the exception of being able to manage the subscription.
External Resource
This is someone who usually is a freelancer that needs access to Tasks but not much more. They have a similar level of access as the Basic User but we've included this for future use.
The Client
Someone who probably would like to get access to all your stuff but really you only want them to see things you want them to see. Like outstanding invoices and access to Files you share with them but apart from this you don't really need much more.
Dashboard
Projects
Companies & People
Companies
Contacts
Users
Money
Items
Templates
Bank Reconciliation
Bank Import
Scheduled
Bank Transfers
Manual Journal
Chart of Accounts
Reports
Reports
Who Owes Me
What I Owe
General Ledger
Profit & Loss
Tax Report
Time
Statement
Subscription
Subscription
Overview
Companies exist for two main reasons:
- Assigning Projects & other related things
- Grouping Contacts and Users
1. Assigning – Projects and other related things
Most things in Beeswax, like Projects, Quotes or Invoices, need to be assigned to a Company. These things can’t be assigned to a specific User or Contact.
Why? Because small businesses, those businesses that Beeswax is specifically built for, generally work with and provide services to other businesses rather than individuals or customers. In other words, we think of Beeswax as being a B2B application rather than a B2C. It’s one of the key assumptions we’ve made when building Beeswax.
Remember a Quote or Invoice is technically a legal document that relates to the obligations that your business has to another party. And therefore the name of the other party, which is usually a business, should be stated specifically. Of course you will have a contact who will receive documents from you but they are still technically representing the third party and are usually not themselves obligated to fulfil their financial obligations to pay you.
It’s the company or business they represent. When they leave the company still owes you money.However, while we think of these entities as Companies, it’s not to say that a Company can’t be something else. That’s for you to decide.In any case just remember that Projects, Invoices, Quotes and Expenses are all allocated to this idea, this entity, this concept, that we call a Company.
2. Grouping Contacts & Users
SM
JC
DJ
JC
It’s the way Beeswax groups or organises Users and Contacts. We think it makes sense to keep all Users and Contacts under the specific Company that they are associated with.