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