Hi everyone! Sangeetha here, Senior Product Marketing Manager at DataSnipper, and welcome to this week's Tips & Tricks.Quick intro for anyone who's new here. Before I moved into product marketing, I spent years as an auditor. So when I write these, I'm writing about the tasks I actually did, not features I read about on a slide. Batch payment testing is one of those tasks, and it's the one I want to go deep on this week.If you've done it, you know the shape of it. You have a batch payment (one lump sum that covers many invoices), and you need to prove two things. First, that every invoice inside the batch is legitimate and adds up to the batch total. Second, that the batch actually left the bank. That means pulling together the batch payment schedule, the individual invoices behind it, and the bank statement, then reconciling across all three. During busy season, with dozens of batches, this is exactly the kind of repetitive, high-volume work that eats your week.This is where Excel
