Budgeting Tip: Separating Types of Expenses in your Chart of Accounts

If your programming runs from fall to spring/early summer, you most likely have a fiscal year that begins in mid-summer, and you most likely are presently in budget season. Here are two quick tips for organizing your Chart of Accounts. What is a Chart of Accounts? A Chart of Accounts is less a chart in the visual sense than it is a list of all the account names your organization uses within its accounting software, and the reports that flow from it, to record all your financial transactions. This includes both your … Read more

An Excel Trick To Quickly Increment Dates For Each Row

You’ve probably found yourself in a position at some point or another where you needed to create a bunch or rows with dates that increased/decreased by a fixed amount for each row. You could spend your valuable time entering them manually or use this oldie but goodie click-and-drag trick to fill in those dates in seconds. Make sure your column is formatted for dates and enter the increment you need to use. In this example, I want each row to decrease by one day. Highlight both cells and look for a tiny … Read more

A Simple Way to Distinguish Contractors’ Pay from Reimbursements

Many arts organizations will have artists as well as other vendors that need not only payment for their service fees, but also will incur various reimbursable expenses while providing their contracted services. Artists performing for you but who are based in other cities will have travel expenses. Even if airfare, hotels, and rental cars are paid directly by the producing organization, expenses like rideshares or gas for the rental car, and checked baggage fees, might be paid by the guest artist out of pocket during their work period for your organization. An … Read more