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

Are You Ready For Mastercard’s New Recurring Payment Rules?

Earlier this fall, Mastercard issued new rules for merchants processing recurring credit card charges on its network (essentially, merchants who process recurring charges to a Mastercard-branded credit card, regardless of the issuing bank). As originally announced, these new rules would have presented extra and potentially burdensome administrative work for small nonprofits, including arts organizations, that have recurring monthly donations (though enforcement for the recurring donation case was due to begin later than for other types of recurring charges). Stripe, one of the major payment processors, has a helpful breakdown of the new … Read more