All payments collected

FreshBooks

 

FreshBooks is an cloud-based invoicing, accounting and billing software.

All payments collected (in current month)

Query Text

SELECT Client.FirstName, Client.LastName, Payment.Type AS Method, Payment.Notes AS Note, Payment.Date, Payment.Amount
  FROM Payment
LEFT OUTER JOIN Client ON Payment.ClientId = Client.Id
WHERE (date(date(Payment.Date), 'start of month') = date('now', 'localtime', 'start of month'))
  

Open Query